Re: differences between null and empty varchar2

According to the ISO standard they are two different concepts, but under the current implementation of Oracle they are treated identically. If you dig around in the README notes that comes with Oracle you'll eventually find a section where it says that at some time in the future Oracle will change their treatment of '', but for now we have to accept that it does not conform to the standard.

Ken

Vincent Lemaire wrote:

> when I create a table with a not null varchar2 field, and as I put an empty
> value '' into this field, I get the error '... null inserted...'
> logically, null and '' should not be the same
> could someone help me to resolve this very disturbing confusion, so that I
> could sleep quiet ?
Received on Fri Aug 06 1999 - 06:48:01 CDT