Why my tables' names are converted into lowercase in phpmyadmin?

Question

I am using wamp server 2.0 on Windows XP. Whenever I create a table with some uppercases in name, it is converted to lowercase.

For example:

I create: UserInfo
phpmyadmin convert it to: userinfo

I am using ubuntu/phpmyadmin in office but this problem does exists there.

from where can I fix this. Thanks

Answer 1

There is a directive for forcing table names to lower case.

You want to set the lower_case_table_names value to 0.

You can read more about it from MySQL documentation here

Answer 2

I've tried what's been suggested here, i must inform that

lower_case_table_names = 0

doesn't work in xampp, it crashes MySQL service at the moment you restart it. Yet

lower_case_table_names = 2

didn't crash, and apparently worked... at least it allowed me to insert a db with camel case.

Answer 3

In windows the default value for lower_case_table_names = 1.

You need to change or add this value to my.ini file in your mysql folder..

If this line is not found, then add it under [mysqld]

lower_case_table_names = 0

And then restart the wamp services, it will work :D

Answer 4

You must find file my.ini in your mysql folder and change, or add this line:

lower_case_table_names value = 0

Answer 5

You need to find file my.ini in your mysql folder and change, or add this line at bottom:

lower_case_table_names = 2

Answer 6

It was not phpMyAdmin. MySQL did this.

p.s. It is a bad practice to use camelCase in databases. Use _underlines instead. :)

Answer 7

• Step 1: open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini or open xampp click on mysql -> config then open my.ini file
• Step 2: Search [mysqld] for: # The MySQL server [mysqld] in my.ini file
• Step 3: Add this :lower_case_table_names=2
• Step 4: save the file and restart MySQL service or (Xampp)