[Dovecot] Case sensitive nightmare
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:
>> 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