Case sensitive tables?
Permalink
If I export the database in phpmyadmin it will convert all tables to lowercase... does anybody know a way around this?
Also why concrete uses case sensitive tables instead all lowercase.. it's easier to avoid these problems :)
Also why concrete uses case sensitive tables instead all lowercase.. it's easier to avoid these problems :)
I wrote this sql file to fix up the database after I got the 'Fatal error: Uncaught exception 'ADODB_Exception'. when I moved my site from WebMatrix to a linux web hosting system.
This changes the lowercase WebMatrix version to the case sensitive version using RENAME TABLE statement. Just change the file extension of the attached file to sql.
This changes the lowercase WebMatrix version to the case sensitive version using RENAME TABLE statement. Just change the file extension of the attached file to sql.
Anyone got this file for 5.5?!
This thread is way out of date. A better way of doing it is now available in this addon:
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
with further info in this howto:
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
with further info in this howto:
http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...
This is for version 5.2.2:
RENAME TABLE areagroupblocktypes TO AreaGroupBlockTypes; RENAME TABLE areagroups TO AreaGroups; RENAME TABLE areas TO Areas; RENAME TABLE ataddress TO atAddress; RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries; RENAME TABLE ataddresssettings TO atAddressSettings; RENAME TABLE atboolean TO atBoolean; RENAME TABLE atbooleansettings TO atBooleanSettings; RENAME TABLE atdatetime TO atDateTime; RENAME TABLE atdatetimesettings TO atDateTimeSettings; RENAME TABLE atdefault TO atDefault; RENAME TABLE atfile TO atFile; RENAME TABLE atnumber TO atNumber; RENAME TABLE atselectoptions TO atSelectOptions; RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;
Viewing 15 lines of 127 lines. View entire code block.
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...