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 (<fieldname>='<value>') 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.