> > Hi Thomas,
The documentation says that for Oracle compatibility mode: - Empty strings are treated like NULL values. But in the following cases an empty string in Oracle compatibility mode seems not to be treated like NULL. The following query in Oracle DB returns true, whereas in H2 with MODE=Oracle doesn't: SELECT true AS result WHERE '' IS NULL; And the following query in Oracle DB returns nothing (empty result set), whereas in H2 with MODE=Oracle returns true: SELECT true AS result WHERE '' = ''; The same behaviour appears when reading the values from a table. And when inserting an empty string in H2 with MODE=Oracle it is not converted to NULL whereas in Oracle DB NULL is stored and not an empty string. The statements where executed on H2 1.3.174 (2013-10-19) Do I need do set any other parameter for the compatibility mode to work correctly or is it simply not working yet? Regards, Mike -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.