empty string == NULL

From: Andreas Steidle <andreas_at_fh-konstanz.de>
Date: Thu, 23 Dec 1999 00:34:23 +0100
Message-ID: <38615f57.0@news.uni-ulm.de>

From the oracle doc:

Do not use null to represent a value of zero, because they are not equivalent. (Oracle currently treats a character value with a length of zero as null. ... [1])

Is there a workround for this contardictory semantik garbage? A string is a string, even if it's empty!!! Perhaps some env-var?? In other words: Is there a way to make Oracle remember a '' and NOT convert it to NULL ???

thanx, Andreas

[1] However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as NULLs.

Hope this will happen very soon as default behavoir. Received on Wed Dec 22 1999 - 17:34:23 CST