Re: Null and empty string

Quoting Oracle9i documentation:

A string of zero length ('') is not equivalent to a NULL value. According to the ANSI SQL 1992 Transitional standard, a zero-length or empty string is not the same as NULL. Ensure that applications do not treat empty strings and NULL values equivalently.

This can be found under " Oracle8 and Oracle8i Desupported and Deprecated Features". I'd suggest NOT to use an empty string as a representation of a NULL value as they are semantically different.   best regards

"Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> writes:

> In Oracle null and empty string are the same. Not ANSI standard, but that's
> the way it is.
>
> --

-- 
===============================================================
Miko,B3(Baj Morzy
Instytut Informatyki           Institute of Computing Science
Politechniki Pozna,Bq(Bskiej       Poznan University of Technology
ul. Piotrowo 3A                ul. Piotrowo 3A
60-965 Pozna,Bq(B                  60-965 Poznan, POLAND

e-mail: DONTLIKESPAMMikolaj.Morzy_at_cs.put.poznan.pl
tel.  : +48 61 665 21 27
fax   : +48 61 877 15 25
===============================================================