
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 |
      /  \_/  \
    .' /     \ `.
  /~  |       |  ~\
(_   |       |   _)
    ~ \       / ~
     __\_>-<_/__
     ~;/     \;~



Fri, 6 Aug 1999 05:25:22 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
[PHP3] mysql is case sensitive? (fwd)