Re: NULL behavior in ORACLE vs SYBASE

In article <D8FCJH.GMt_at_cs.dal.ca>, ae873_at_ccn.cs.dal.ca (Murray Kaiser) writes:

[deleted]  

|> mmmmmmm interesting, yet if you
|>
|> INSERT INTO table VALUES (''''''); <---- yes, that is six single quotes
|> and then do a
|>
|> SELECT * FROM table;
|> you will get
|>
|> column
|> --
|> ''
|>
|> or
|>
|> SELECT * FROM table
|> WHERE column = '''''';
|> will also return the same thing!
|>
|> I don't understand it but there it is
|>
|> --
|> Murray Kaiser | Usual gutless disclaimer..
|> Nova Scotia Power | Opinions are mine and not necessarily
|> (Murray.Kaiser_at_NSPower.NS.CA) | shared by my employer

This isn't a NULL being inserted, this is a string consisting of two single quotes. Received on Fri May 12 1995 - 00:00:00 CEST