You can escape it using the single quote twice abc''s question
Dave
----- Original Message -----
From: "Venkata Ratnam Vadlamannati" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 06, 2001 9:49 PM
Subject: Inserting special characters
> Hi all
>
> Can anybody suggest me how to insert into a text
> column with text such as "abc's question", "he said "I
> am not a culprit", it's your fault" etc.,
>
> I'm using jdbc-odbc drivers for sql7.0. and HTML forms
> with JSP to process backend.
>
> As the string is with characters such as ", ', normal
> insert statement fails
>
> please suggest me a workaround to do the above
>
> thanks in advance
>
> Venkat
>
> PS:Plese email your suggestions directly to
> [EMAIL PROTECTED]
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
