Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dont Quote Me

Re: Dont Quote Me

From: Mark Bole <makbo_at_ecis.com>
Date: Mon, 03 Sep 2001 07:45:02 -0700
Message-ID: <3B93976D.DABA07A0@ecis.com>


From the Oracle documentation:

 To represent one single quotation mark within a literal, enter two

    single quotation marks.

Raymond Sebuwufu wrote:

> Dear all I am trying to insert data into a
> varchar(255) field. Normally this would not be a problem but the data has
> single quotes in it which confuses the SQL interpreter.
>
> Ex. INSERT INTO TABLE (ADDRESSFIELD) VALUES ('20 Dunaway's Lane, London');
>
> The apostophe is interpreted by SQL as terminating the string.
>
> I have tried both escape sequences "\" and "{}" however they just seem to
> add themselves to the final data which I do not want. I want the data in the
> database as it is present without the escape sequences.
>
> Please reply as soon as you can if you know the answer to this most
> frustrating problem.
>
> Regards
>
> Raymond
Received on Mon Sep 03 2001 - 09:45:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US