Re: Null values and Varchar2 fields

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 26 Jul 1999 07:45:31 -0400
Message-ID: <379C4A5A.BF79DFBC@Unforgettable.com>

Filip Hanik wrote:

> Hi,
> I have a question,
> how come when I set a column (type varchar2) to be a zero length string ('')
> the value gets ignored and the column is null?

Because there is no concept within Oracle that allows zero length strings. This is not consistant with the ISO standard and will eventually be corrected in future releases. The defined behavior at this point is for zero-length strings to be treated as null.

Ken Received on Mon Jul 26 1999 - 06:45:31 CDT