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 :)

 
mixedpixel replied on at Permalink Reply
mixedpixel
This problem is well-known and this add-on is a remedium:
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
jsghumphreys replied on at Permalink Reply 1 Attachment
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.
awestrope replied on at Permalink Reply
Anyone got this file for 5.5?!
JohntheFish replied on at Permalink Reply
JohntheFish
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...
mozalan replied on at Permalink Reply
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;
JohntheFish replied on at Permalink Reply
JohntheFish