Subject Re: RES: RES: RES: [firebird-support] String Concatenation with null field
Author Lucas Franzen

Fabrício Fadel Kammer schrieb:
> OK,
> Are there a solution to I create a new database using the metadata of my
> actual database setting the NOT NULL and defining the default = ''
> (empty strings) ???
> And how can I migrate the data from my old database (where I can have
> null strings) to my new database (where I couldn't have null string)
> setting the null string fields to empty strings ''?

Why not adding insert and update triggers that will set NULL values to
empty strings?
For existing data use a dummy update afterwards, so the trigger will
care to set everything to '' where it is still NULL.

This way you don't have to move the database.