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.
>
Use ''
--
_/ _/ _/_/_/ ----- Rafał Jank yankee_at_wp.pl -----
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625
_/ _/ _/ --------==* http://szukaj.wp.pl *==----------
Received on Mon Sep 03 2001 - 09:29:02 CDT
