Subject Re: [firebird-support] empty string=null ?
Author Martijn Tonies

> Some said in old sql standard, zero-length (empty) string will be
converted to
> null, eg,

This isn't true. The SQL standard differs between NULL and ''.

> update foo set bar=''
> will effectively become
> update foo set bar=null

See above.

> Is this true for FB1.5 and FB2 ?

No, Fb follows the SQL standard. NULL and '' are different.

> A related question, in DDL, is
> a varchar(10) default ''
> equivalent to
> bar varchar(10) default null

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!