[Dovecot] Case sensitive nightmare

Michael Paesold mpaesold at gmx.at
Mon Dec 12 09:27:09 EET 2005

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.

Best Regards,
Michael Paesold 

More information about the dovecot mailing list