Fabricio,


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.

Luc.