Posted on Thu, 16 Nov 2006 15:02:49 +1100 by author Daniel Kasak <[EMAIL PROTECTED]> > In MySQL the default seems to be to have case insensitive matches ( not > sure about other databases ), so in this case you wouldn't need the > 'lower' function. I have tested my dbmail installation ( on a test box > at the moment ), and mine is doing case insensitive matches:
The behavior you mentioned is depending on what character set is used for column searched. For me, the default character set for whole DBMail tables is "binary" for some reasons, search is done in case sensitive by default. mysql> SELECT userid FROM dbmail_users WHERE userid='maenaka'; +---------+ | userid | +---------+ | maenaka | +---------+ 1 row in set (0.00 sec) mysql> SELECT userid FROM dbmail_users WHERE userid='MAENAKA'; Empty set (0.00 sec) -- UEMURA (fka. MAENAKA) Tetsuya <[EMAIL PROTECTED]>
