Subject Re: [firebird-support] Escape Character for apostrophe?
Author Milan Babuskov
barfingdog_2004 wrote:
> How do you escape an apostrophe, so it can be
> part of the text in an insertion operation?

Use another apostrophe, like this:

insert into player values ('Shaquille O''neal');

Or just use parameterized statement like this:

st->Prepare("insert into players values (?)");
st->Set(1, "Shaquille O\'neal");

> I can read articles on the support news server
> mirror, but I have to go through Yahoo's inferior
> interface (no spell checker, no indentation when
> reading posts, no grouping with stepped
> indentation of related posts) in order to post.

You can use any e-mail client to post messages. Just send them to
firebird-support@yahoogroups.com


--
Milan Babuskov
http://fbexport.sourceforge.net