Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: empty string == NULL
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
![]() |
![]() |