|Subject||Re: RES: [firebird-support] String Concatenation with null field|
> 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 theMartijn Tonies
> > 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
> > my database defining all string fields as NOT NULL and the default
> > as a empty string.
> > If I alter the database I'll need to import the actual database to a
> > 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
> That's because Oracle goes against all standards and treats NULL
> as '' (empty string) for character columns.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!