Re: insert of spesial characters
From: <vinay.g.vaze_at_boeing.com>
Date: 1997/10/15
Message-ID: <876949986.2973_at_dejanews.com>#1/1
Date: 1997/10/15
Message-ID: <876949986.2973_at_dejanews.com>#1/1
use set scan off before inserting the record.
In article <01bcd62b$30fe4800$4be6ccc3_at_adekvat>,
"Pål BergersenAdekvat C AS" <pal.bergersen_at_hm.telia.no> wrote:
>
>
> Asume table A
> (
> A varchar2(80)
> )
>
> I am trying to insert the string 'Day & Night' into table A.
> Sql*plus prompts me for input on the &.
>
> I have tried with ' ' Day & Night' '.
> This gives me 'Day and Night' in the database.
> Thanks.
>
> pal.bergersen_at_hm.telia.no.spam
>
> Please cc to this adress without the .spam
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Oct 15 1997 - 00:00:00 CEST