On 16-10-2013 00:17, Helen Borrie wrote: > At 06:17 a.m. 16/10/2013, [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. > > 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
