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
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