Re: empty string == NULL

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 23 Dec 1999 13:58:59 GMT
Message-ID: <38622AA3.C3487D49@edcmail.cr.usgs.gov>

I believe that this will change with future releases of Oracle. According to the new SQL-99 standards, an empty string is different than a null value. Oracle has said that they will conform to the SQL-99 standards.

HTH,
Brian

Andreas Steidle wrote:
>
> From the oracle doc:
>
> Do not use null to represent a value of zero, because they are not
> equivalent. (Oracle currently treats a character value with a length of zero
> as null. ... [1])
>
> Is there a workround for this contardictory semantik garbage? A string is a
> string, even if it's empty!!! Perhaps some env-var??
> In other words: Is there a way to make Oracle remember a '' and NOT convert
> it to NULL ???
>
> thanx, Andreas
>
> [1] 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.
>
> Hope this will happen very soon as default behavoir.
Received on Thu Dec 23 1999 - 07:58:59 CST