1st annoyance of MySQL

[Man-wai CHANG]

Man-wai CHANG wrote:
> 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.
> 

Dam... mysql.. default character set and collate sequence is
case-insensitive... dam dam dam.... Need to add 2 lines into
/etc/my.cnf to support the full ASCII set properly:

[mysqld]
default-character-set=latin1
collation-server=latin1_bin

-- 
  .~.    http://changmw.homeip.net
 / v \   Linux 2.6.14.4
/( _ )\  (Ubuntu 5.10)  22:29:01 up 10 days 11:26
  ^ ^    load average: 0.42 0.45 0.48