[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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

---------- Forwarded message ----------
Date: Fri, 6 Aug 1999 15:21:44 +0800
From: bben <bben(at)wisdomcomputer(dot)com>
Reply-To: bben <bben(at)163(dot)net>
To: phpmailist <php3(at)lists(dot)php(dot)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 |
/ \_/ \
.' / \ `.
/~ | | ~\
(_ | | _)
~ \ / ~
__\_>-<_/__
~;/ \;~