Subject escaping apostrophes
Author steve_carter_ben
I've read the posts about escaping apostrophes. But I can't seem to
get it to work. I'm using Delphi 5. I've tried QuotedStr and even
AnsiQuotedStr. I've even written code to insert the two single quotes.
I use this in an update storede procedure and it fails silently, no
exception. I have a last_updated field and trigger, and it shows the
record was not updated.

If I do something in IBExpert or some other tool like SET title
= 'Joe''s' it works. Why does the Delphi code not work?

By the way, I had a similar problem with Delphi, the BDE, and MySQL. I
was hoping Firebird and IBObjects would not have this problem, and
from what I've read here, it shouldn't! Does the CharSet of the
database have anything to do with this, maybe?