Tony Foiani writes:
> >>>>> "Michael" == Michael Peppler <[EMAIL PROTECTED]> writes:
>
> Michael> I believe that SQL-92 mandates that a non-null string be at
> Michael> least one character in length.
>
> Interesting. The Oracle docs say:
<snip>
> Michael> Certainly Sybase (and I presume MS-SQL) behaves this way.
>
> Well, as I indicated, Informix seemed to be happy putting a
> zero-length string into a NOT NULL column. More importantly (now that
> I think about it a bit longer), it was happy to agree that the
> condition '' = '' is true, instead of seeing that as NULL = NULL, and
> returning false.
There was a fairly long thread in comp.databases.sybase on this
issue. Joe Celko weighed in with this comment:
4) Attempting to put an empty string into a VARCHAR(n) column will
produce a single blanks. Attempting to put a string that is too long
into a VARCHAR(n) column, will raise an exception.
(The thread is "Empty String Converted to NULL" started on 1/4/2001 in
case you're interested.)
So it seems that in this case Oracle is not ANSI compliant (if I
understood what you quoted correctly :-)
Michael
