Re: differences between null and empty varchar2

I would say that logically null meand no value which is the same as an empty string (''). There's nothing between the quotes, so there's no value. It's not the same as a space (' ') however.

I've never looked at it in hex. is X'00 the same as no value?

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 - 11:06:10 CDT