From: svemulapalli@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: How to insert a ' into an field
Date: Tue, 10 Oct 2000 12:50:33 GMT
Organization: Deja.com - Before you buy.
Lines: 29
Message-ID: <8rv3an$uo2$1@nnrp1.deja.com>
References: <39e2fa9a@news.netfab.de>
NNTP-Posting-Host: 208.17.213.42
X-Article-Creation-Date: Tue Oct 10 12:50:33 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x72.deja.com:80 (Squid/1.1.22) for client 208.17.213.42
X-MyDeja-Info: XMYDJUIDsvemulapalli


use two single quote where ever quote exists in your string
e.g :
insert into [table] values ('14 jours après l''implantation');
Suresh

In article <39e2fa9a@news.netfab.de>,
  "Oliver Huppert" <ohuppert@pikon.com> wrote:
> Hi there
>
> I've to insert a String conaining a ' into an table.
> The SQL-Statement:
>
> insert into [table] values ('14 jours après l'implantation');
>
> or so
>
> don't work, because of the ' after the l. Oracle means the String
 ends here.
>
> Plsease help me.
>
> Nice regards
> Oliver Huppert
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.