Subject Re: RES: [firebird-support] String Concatenation with null field
Author Martijn Tonies

> I agree with you, but I've a lot of clients using my software and the
> NULL string field was not important when the software was developed.
> I'll have a lot of work and perhaps problems with validations if I alter
> my database defining all string fields as NOT NULL and the default value
> as a empty string.
> If I alter the database I'll need to import the actual database to a new
> and do the validations of null fields.... It'll give me a lot of work!
> I stay surprise with this because it doesn't occour in Oracle databases.

That's because Oracle goes against all standards and treats NULL
as '' (empty string) for character columns.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!