Re: NULL behavior in ORACLE vs SYBASE

From: Ari Kaartinen <Ari.Kaartinen>
Date: 1995/05/12
Message-ID: <3ourdd$e4g_at_idefix.eunet.fi>#1/1


ae873_at_ccn.cs.dal.ca (Murray Kaiser) wrote:
>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
>--
>''
>I don't understand it but there it is

 This happens because two single quotes is used to represent one single quote within literal. That string of six quotes then becomes

begin of literal first quote second quote end of literal

        '                ''           ''                  '
 So you end up entering two single quotes to the table.

---
Ari Kaartinen Tekla Oy, Koronakatu 1, SF-02210 Espoo Finland Ari.Kaartinen_at_tekla.fi Tel: +358-0-8879511 Fax: +358-0-8039489 Received on Fri May 12 1995 - 00:00:00 CEST

Original text of this message