[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2161) hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect, sqltype = char, NUL but not NULL.

[Shutra (JIRA)]

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect, sqltype = char, NUL but not NULL.
----------------------------------------------------------------------------------------------

         Key: HHH-2161
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2161
     Project: Hibernate3
        Type: Bug

 Environment: hibernate-3.2.0.cr5.jar, postgresql 8.1.x
    Reporter: Shutra


When insert, if  the sql type is char and the value is null, then the generated sql is like this:

insert  into table (column) values(?),

then the postgresql said: 
insert into table(column) values(NUL)
but not insert into table(column) value(NULL).

Important: the sql type is character(in mapping file) and the java type is char.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira