Help
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??
Page 1 of 1
Why my friends' phpmyadmin can't create Uppercase table name??
Rate Topic:
#1
- Advanced Member
-
- Group: Members
- Posts: 537
- Joined: 21-June 10
Posted 08 July 2010 - 06:20 AM
“The most likely way for the world to be destroyed, most experts argue, is by accident. That’s where we come in; we’re computer professionals. We cause accidents.” - Nathaniel Borenstein
Yii Playground : Collaborative demo apps. You can join to improve it too!
My Team's Blog: In Indonesian.
Yii Playground : Collaborative demo apps. You can join to improve it too!
My Team's Blog: In Indonesian.
#2
- Standard Member
-
- Group: Members
- Posts: 287
- Joined: 10-November 09
- Location:Blackpool, United Kingdom
Posted 19 July 2010 - 12:55 PM
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.
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.
#3
- Advanced Member
-
- Group: Members
- Posts: 537
- Joined: 21-June 10
Posted 22 July 2010 - 08:55 PM
outrage, on 19 July 2010 - 12:55 PM, said:
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.
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
“The most likely way for the world to be destroyed, most experts argue, is by accident. That’s where we come in; we’re computer professionals. We cause accidents.” - Nathaniel Borenstein
Yii Playground : Collaborative demo apps. You can join to improve it too!
My Team's Blog: In Indonesian.
Yii Playground : Collaborative demo apps. You can join to improve it too!
My Team's Blog: In Indonesian.
Share this topic:
Page 1 of 1