Re: [stellation-res] Comments table, why insert empty comment?

[Ringo De Smet <ringods@xxxxxxxxxxx>]

 --- Dave Shields <shields@xxxxxxxxxxxxxx> wrote: 
> I picked "" over NULL as we don't use NULL in any other table.

Inserting '' or "" in Oracle VARCHAR2 is transformed to NULL. If I
change the column to allow NULL, the INSERT statement works.

Can the Comments table creation be changed to allow null in the
s_Comments column?

Ringo

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com