On 15-10-2013 19:17, russell@... wrote:

>
>
> running inside Delphi if I use the query
>
>
> select * from person where email = :email
>
> if the email address is a@... then it is fine, but if the email
> contains an apostrophe a'oneill@b,com then it fails to locate the
> record. Even if I use a string replace rather than a parameter it fails.
>
> In FlameRobin
>
> select * from person where email = 'a''oneill@...'
>
> is fine.
>
> any ideas?

Are you sure the record (or the string in code) actually contains an
apostrophe (U+0027) and not an U+0060 (GRAVE ACCENT), U+00B4 (ACUTE
ACCENT), U+2018 (LEFT SINGLE QUOTATION MARK) or U+2019 (RIGHT SINGLE
QUOTATION MARK)?

Mark
--
Mark Rotteveel