Why my friends' phpmyadmin can't create Uppercase table name??

Just curious…

so my friend is using WAMP version 2i, and his phpmyadmin unable to create a uppercase table name…

everytime he create, for example, ‘Inventory’ the phpmyadmin will generate ‘inventory’…

why is it??

MySQL defaults to lowercase table names in Windows which can be a problem when importing your db on a Linux server.

This can be changed by editing your ‘my.ini’ file found in ‘path-to-mysql\bin\my.ini’ and adding the following line:

lower_case_table_names=0

There are caveats to this approach though so you’re much better sticking to lowercase table names if possible.

Hope this helps.

Ow… I see. Thank you :)