And this can be did in Firebird? Isn't it a good idea?

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Martijn Tonies
Enviada em: terça-feira, 10 de janeiro de 2006 08:10
Para: firebird-support@yahoogroups.com
Assunto: Re: RES: [firebird-support] String Concatenation with null
field


Hi,

> 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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]