mysql: varchar and case sensitive

[Jerry Swanson]

Column type is username varchar(100).

When I do select from database:
        "select * from user where username='John'";  //returns one row
        "select * from user where username='john'"; //returns one row

The records in the database has username 'John'.

Why it  isn't case sensitive? 'John" and 'john' .. are two different strings..?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]