[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