On 15-10-2013 19:17, [email protected] wrote: > > > running inside Delphi if I use the query > > > select * from person where email = :email > > if the email address is [email protected] 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''[email protected]' > > 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
