Subject Re: [ib-support] OT: SQL Question
Author Tumelis Giedrius IF 5/1
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.