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

It was not phpmyadmin. Mysql did this.

p.s. It is a bad maner to use camelCase in databases. Use_underlines. :)