Re: TEXT and NULL...

On Mon, 17 Jun 2002, Egon Sommer wrote:
> Hallo all,
>
> Does it make any difference to save "no data" in a column with type TEXT or BYTEA as "" (empty string) or null?
> Is one of it faster or more wast of memory?

Always store NULL instead of empty strings. This will it make much
more easier in programming where you don't have to bother about
two conditions (NULL and empty string). An empty string on the
other hand may be a value in an application context where NULL is per
definition always the same. Storing NULL values is a good feature
of DBMS so use it ;-) Querying NULL values is part of the SQL-Syntax.

Best regards
Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti http://www.thinx.ch
ThinX networked business services Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~