Hello John, (01)
> Recommendation: There are *always* better solutions than using NULL. (02)
Like 99999 for an unknown ZIP code ? ;-) (03)
In the general case, out of range values are not better because (04)
-They require special handling
-The range may change
-The range may be not clearly defined or unlimited (05)
The special handling is often not required for NULL because SQL already
behaves in the intended way and NULL values from the database are often
converted to similar NULL values in the programming language (Why do
modern programming language have a similar concept ? Are they broken too?). (06)
What other solutions for getting rid of NULL were you thinking of ? (07)
Regards, (08)
Michael Brunnbauer (09)
--
++ Michael Brunnbauer
++ netEstate GmbH
++ Geisenhausener Straße 11a
++ 81379 München
++ Tel +49 89 32 19 77 80
++ Fax +49 89 32 19 77 89
++ E-Mail brunni@xxxxxxxxxxxx
++ http://www.netestate.de/
++
++ Sitz: München, HRB Nr.142452 (Handelsregister B München)
++ USt-IdNr. DE221033342
++ Geschäftsführer: Michael Brunnbauer, Franz Brunnbauer
++ Prokurist: Dipl. Kfm. (Univ.) Markus Hendel (010)
_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J (011)
|