top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Case sensitivity in mysql?

+2 votes
327 views

I have 2 servers, one is running 5.5.25a and the other 5.0.77. They both have the same collation and character set:

mysql> SELECT COLLATION(VERSION());
+----------------------+
| COLLATION(VERSION()) |
+----------------------+
| utf8_general_ci |
+----------------------+
1 row in set (0.00 sec)

mysql> show variables like '%_server';
+----------------------+----------+
| Variable_name | Value |
+----------------------+----------+
| character_set_server | utf8 |
| collation_server | utf8_bin |
+----------------------+----------+
2 rows in set (0.00 sec)

Yet the 5.5.25a server is case sensitive as you would expect, but the 5.0.77 is not. How can I make the 5.0.77 server case sensitive?

posted May 20, 2014 by Satish Mishra

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Please provide the output of   SHOW VARIABLES LIKE 'character_set_%'; and SHOW VARIABLES LIKE 'collation_%';

and also explain what exactly you mean by "is case sensitive". Are you referring to database and table names being case sensitive here, or to comparisons (=, LIKE) on textual values? Seeing a few example queries and the different results returned by 5.0 and 5.5 would help.

Similar Questions
+1 vote

I have observed using tomcat 7.027 and 6.026 an issue with BASIC authentication. My intent was to have both user names and passwords be case sensitive.
I know of nothing I did that would change that. The database table is plain vanilla. Passwords are case sensitive,but upper or lower case usernames work. Is there any way to prevent this?
Operating systems are windows 7 and windows Server 2008R2 both 64 bit.

0 votes

How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.

...