At 10:22 AM 8/3/00 -0400, Bruce Momjian wrote:
>> Oracle allows it, and returns NULL. Oracle's fairly trustworthy
>> on low-level standards compliance over things like NULL (not
>> entirely, though - it treats '' as NULL in the VALUES list of
>> an INSERT, though not elsewhere, for instance).
>
>So you can't get a zero-length string into a column in Oracle.
>Interesting.
The killer is it makes porting from Oracle to Postgres or another
DB that does it right a pain in the ass.
I've got a lot of experience with this particular issue due to the
OpenACS web toolkit (arsDigita's stuff ported from Oracle to Postgres).
- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.