Grant Maxwell wrote: > Hi > > Merry Christmas to all (who celebrate Christmas) > > We are having an issue with case sensitivity of sender names. We store > the sender and recipient email addresses in a single entities sql > table. The records should be > unique on email address and from an sql perspective they are (ie > mary.sm...@smiths.com > is distinct from mary.sm...@smiths.com). However from an application > point of view they are the same - or should be treated as the same - > and only have one record. > > I proposed to alter the $msginfo->sender assignment to > tolower($msginfo->sender) in amavisd. > > what mail server are you using? what sql? only sql server I know of that is case sensitive is sqlite3. what var type is the column?
I would think the sql server should return the Mary or mary, no matter what. -- Michael Scheidell, CTO Phone: 561-999-5000, x 1259 > *| *SECNAP Network Security Corporation * Certified SNORT Integrator * 2008-9 Hot Company Award Winner, World Executive Alliance * Five-Star Partner Program 2009, VARBusiness * Best Anti-Spam Product 2008, Network Products Guide * King of Spam Filters, SC Magazine 2008 _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.secnap.com/products/spammertrap/ _________________________________________________________________________ ------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/