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