>> 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 thanks for the prompt reply.

We are using postgresql 8.3 as the database, the mail system is not  
relevant to the issue but is postfix.

In my experience sql is always case sensitive unless you specify  
otherwise in queries. Certainly it is stored case sensitive (at least  
in postgres) and Im not aware of a feature to set it to behave in a  
non-case sensitive fashion.

If you believe that can be done then I would be most interested in how  
it is achieved.

kind regards
Grant





------------------------------------------------------------------------------
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/ 

Reply via email to