Hi to all,

I think that you can do that writting the special character into single
quotes.

By example:

INSERT INTO prueba VALUES (1, '''MY NAME''');

that put the 1 into the first field, and put 'MY NAME' into the second field
(of course like data).

>On Fri, 18 May 2001, Rob Schuff wrote:
>
> > Folks, > > the following e-mail came in to me from a colleague. Does
>anyone have an > answer for this? > > The SQL standard specifies that
>single quotes are to be used around string > literals (='') in SQL
>statements. Some implementations > of SQL allow double-quotes, but many
>require single-quotes. > > Does anyone know of a way to handle saving (with
>SQL UPDATE or INSERT) of > strings that contain internal apostrophes
>(single quotes), preserving the > single quotes within the string?
>
>I am using java client with interbase. When I want insert some data that
>gas unusual charracters , I am using PreparedStatements. setString works
>well with any sort of data.
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com