[Dovecot] Case sensitive nightmare

Erik Petersen cthree at s2ki.com
Mon Dec 12 10:18:51 EET 2005


On 12/11/05 11:27 PM, "Michael Paesold" <mpaesold at gmx.at> wrote:

> Erik Petersen wrote:
> On 12/11/05 7:39 PM, "John Peacock" <jpeacock at rowman.com> wrote:
>>> Searches in MySQL are not case sensitive:
>>> 
>>> http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html
>> 
>> True, WHERE 'FOO' like 'foo' is a match but my user_query is WHERE
>> username = '%u'
> 
> SELECT 'Foo' = 'foo'
> 
> gives 1 (true) to me.
> 
> You have have to declare your columns as VARCHAR(..) BINARY. Then MySQL will
> do no case-folding whatsoever.
> 

My bad. Thanks.



More information about the dovecot mailing list