Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dont Quote Me
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