At 09:59 AM 11/28/00 +0000, Pete Forman wrote:
>Mario Weilguni writes:
> > This gets really bad when the actual data is coming from a
> > webinterface, I've to handle 2 different queries for the case empty
> > string and non-empty string.
>
>In their documentation both Oracle 7 and 8 state:
>
> Oracle currently treats a character value with a length of zero
> as null. However, this may not continue to be true in future
> releases, and Oracle recommends that you do not treat empty
> strings the same as NULLs.
Yeah, but this is harder than it sounds! NULL and '' are indistinguishable
in queries, so how do you treat them differently? Has to be in the
application code, I guess.
- 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.