+1 as far as compatibility is concerned. In Oracle, NULL and '' are the same. Even on popular request, Oracle never corrected that well- known "flaw". Probably, a lot of the database's internals depend on this "feature", too. While it is clearly better to be able to distinguish NULL and '' in a more modern database, such a compatibility mode would be a very interesting feature.
Note also, that -among other reasons- Oracle has introduced the VARCHAR2 type precisely to be able not to adhere to the SQL standard for all time and remain backwards compatible, whereas the Oracle VARCHAR type might eventually treat '' and NULL as distinct values. This Stack Overflow question nicely treats this question: http://stackoverflow.com/questions/203493/why-does-oracle-9i-treat-an-empty-string-as-null In many senses, both Rami and Bryan are correct, depending on the point of view :-) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
