5 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Convert Uppercase...
FromSent OnAttachments
Jeremy DavisAug 9, 2006 3:48 pm 
Jerry AmundsonAug 9, 2006 7:35 pm 
Bernd WurstAug 9, 2006 11:38 pm 
Alessandro VeselyAug 10, 2006 2:41 am 
Alessandro VeselyAug 10, 2006 11:25 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] Convert Uppercase to lowercase username (Dovecot like)Actions...
From:Alessandro Vesely (ves@tana.it)
Date:Aug 10, 2006 2:41:32 am
List:net.sourceforge.lists.courier-users

Bernd Wurst wrote:

If the above is not true, you can use custom query string (have a look at the end of authmysqlrc) and use something like [...] WHERE account=LOWER('$(local_part)@$(domain)') [...]

The default query selects WHERE login_field = "input" so it depends ho you defined that field (MYSQL_LOGIN_FIELD) in the MySQL table:

CHAR values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given.