[RCD] Handling invalid address book entries
chasd at silveroaks.com
Wed Oct 15 19:50:05 CEST 2008
On Oct 15, 2008, at 11:08 AM, Ziba Scott wrote:
> Hi Till,
> Thanks for the response. I'd like to just quote everything and
> stick it
> in the database, but ticket 1463946:
> suggests that there is a set of characters that are undesirable to
> and may cause difficulty sending mail to users with strange names.
A Wikipedia page has a summary of the relevant RFCs
and a specific list of characters.
Apostrophes are particularly bad with SQL statements.
My personal hack is to replace those with the HTML entity '
before SQL, and then convert back ( if I need to ) when reading from
From reading the lists for the spam filtering software we use, e-
mail addresses that _begin_ with a plus can cause problems, as can
addresses with hyphens.
> Which puts us in the position of picking and choosing what should go
> into the database.
Data validation problem, which is true of any input data.
System Admin - Silver Oaks Communications
824 17th Street, Moline IL 61265
List info: http://lists.roundcube.net/dev/
More information about the Dev