[Dovecot] Case sensitive nightmare
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.
More information about the dovecot