[PHP3] mysql is case sensitive? (fwd)

This one takes the cake...by default, I guess, when you create the
column, it is not-case sensitive...you have to create the column as
something like:
COL1 VARCHAR(12) BINARY

to make it case sensitive...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 

---------- Forwarded message ----------
Date: Fri, 6 Aug 1999 15:21:44 +0800
From: bben <bben@wisdomcomputer.com>
Reply-To: bben <bben@163.net>
To: phpmailist <php3@lists.php.net>
Subject: [PHP3] mysql is case sensitive?

hello,

I use mysql3.22.25 on linux,
I found mysql is not case sensitive,
for example,I use : "select 'abc'='ABC'"
It return 1.

How can I set mysql to case sensitive?
Thanks.       .___.      /     \     | O _ O |     /  \_/  \   .' /     \ `. /~  |       |  ~\
(_   |       |   _)   ~ \       / ~    __\_>-<_/__    ~;/     \;~