--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> No, for once it's standard. It's what you do in Firebird, too.-
> ...values('John''s House')

Cool, I'll do that then.

> >[In all current cases where we have single quotes within Strings, we
> >just happen to be using prepared statements, and you can simply pass
> >any String - including those containing single quotes - to
> >PreparedStatement.setString(...)].
>
> I don't know what interface you are using: perhaps it is hiding the
> necessary parsing from you.

Nah, using java so all single-quotes are escaped (\').

Thanks again
Phil