On 16-10-2013 00:17, Helen Borrie wrote:

> At 06:17 a.m. 16/10/2013, 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.
>
> Strange - I thought apostrophes and other diacritics were illegal characters in email addresses. Well, well!

An apostrophe is allowed according to RFC5322 (see 3.2.3. Atom and
3.4.1. Addr-Spec Specification).

Mark
--
Mark Rotteveel