[RCD] Handling invalid address book entries

[chasd]

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:
> http://trac.roundcube.net/ticket/1463946
>
> suggests that there is a set of characters that are undesirable to  
> store
> and may cause difficulty sending mail to users with strange names.

A Wikipedia page has a summary of the relevant RFCs
<http://en.wikipedia.org/wiki/E-mail_address#RFC_specification>
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  
the database.

 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.


-- 
Charles Dostale
System Admin - Silver Oaks Communications
http://www.silveroaks.com/
824 17th Street, Moline  IL  61265

_______________________________________________
List info: http://lists.roundcube.net/dev/