1st annoyance of MySQL

Man-wai CHANG mwchang
Tue Jan 3 07:31:24 PST 2006


By default, it's case-insensitive. You need specify the exact COLLATE
during CREATE TABLE to guarantee a case-sensitive search in the future
queries.

I can't believe that a data storage engine would use such a default. Not
in xBase, nor M$ $QL.

-- 
  .~.    http://changmw.homeip.net
 / v \   Linux 2.6.14.4
/( _ )\  (Ubuntu 5.10)  20:22:01 up 10 days 9:19
  ^ ^    load average: 0.14 0.10 0.03


More information about the Linux-users mailing list