Thanks MArk, I have checked that ---In [email protected], <[email protected]> wrote:
On 15-10-2013 19:17, russell@... mailto:russell@... wrote: > > > running inside Delphi if I use the query > > > select * from person where email = :email > > if the email address is a@... mailto: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@... mailto: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
