Search code examples
mysqlphpmyadminwampserver

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

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

Solution

  • 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