[Dovecot] Case sensitive nightmare

[Michael Paesold]

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