At 09:59 AM 11/28/00 +, Pete Forman wrote:
Mario Weilguni writes:
This gets really bad when the actual data is coming from a
webinterface, I've to handle 2 different queries for the case empty
string and non-empty string.
In their documentation both Oracle 7 and 8 state:
Oracle
Mario Weilguni [EMAIL PROTECTED] writes:
In Oracle, empty strings and null are basicly the same,
Are you sure about that? It'd be a pretty major failure to comply with
SQL standard semantics, if so.
SQL92 3.1 (Definitions):
null value (null): A special value, or mark, that is
On Mon, 27 Nov 2000, Mario Weilguni wrote:
Sorry if I'm posting to the wrong list, but I don't know which list is
appropriate for this question.
I've a question concerning compatibilty Postgres - Oracle. In Oracle,
empty strings and null are basicly the same, but it does not seem to
be
At 12:39 PM 11/27/00 -0500, Alex Perel wrote:
On Mon, 27 Nov 2000, Mario Weilguni wrote:
Sorry if I'm posting to the wrong list, but I don't know which list is
appropriate for this question.
I've a question concerning compatibilty Postgres - Oracle. In Oracle,
empty strings and null are
On Mon, 27 Nov 2000, Don Baccus wrote:
Actually, they aren't the same at all under Oracle or under Postgres.
A null represents a lack of data, whereas an empty string is represents
data of zero length and zero content. Null is a state and not a value.
Unfortunately Mario's entirely