> And this can be did in Firebird?

No.

>Isn't it a good idea?

No.

> > 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com