-1
Dealing with strings I encounter 3 common cases
1) NULL (I call this a NULL string)
2) "" (I call this EMPTY string)
3) "<ONE_OR_MORE_WHITESPACE_CHARACTERS>" (I call this BLANK string)
My naming is non-standard but since I encounter these 3 different situations
I have come up with different names for each of them.
It is completely context dependent whether they should be treated the
same or differently.
Of course I have nothing against acting exactly the same way as Oracle
in Oracle mode.
But generally it is not advised.
- rami
On 6.7.2011 19:44, Bryan wrote:
+1
I am also interested in this. Although unlike Jürg, being a long-time
Oracle DBA/programmer (since version 7), data-wise I don't understand
what an empty string could be besides a NULL (as it is no-data), and
think Oracle handles this correctly and anything else is simply
illogical. We'll just write an adapter to correct the empty strings as
they are returned for now.
Cheers,
Bryan
--
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.
