12 Dec
2005
12 Dec
'05
7:51 a.m.
On 12/11/05 7:39 PM, "John Peacock" jpeacock@rowman.com wrote:
Erik Petersen wrote:
It would seem to me that the queries above would fail for the different variations of the name but they don¹t seem to.
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'
so you can use the information in doc/variables.txt to decide whether you want to treat user names as UPPPER or lower case by default.
I'm using the binary install on Fedora Core 4 -- yum install dovecot -- (0.99.14). I don't see a variables.txt file in the source tarball. I guess I should build from 1.0 alpha source?
Thanks