Forums

SQL Database - Case Sensitive and Insensitive

Permalink
Hi,

I have built a site locally using XAMPP and concrete5 (on Windows) I am now trying to upload my completed site to the production environment but everytime I try, I get Fatal Exception errors when it is trying to use the database that I exported from local and imported to production.

Investigation tells me that this is due to the case in the database being incorrect.

Is there a way to change this? It is really frustrating. I have looked everywhere on the web to try to find something to help change a windows CI SQL database to be compatible with a Linux CS format. Any ideas??
garyjhills
 
tek01 replied on at Permalink Best Answer Reply
First solution ($$$)http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
Second solution http://www.concrete5.org/community/forums/installation/table-names-...


This makes your windows xammp case sensitive: open your /xammp/mysql/bin/my.conf and paste this lower_case_table_names = 0
jordanlev replied on at Permalink Reply
jordanlev
tek01 is correct. And just to clarify, the links he provided are what you do to change a database that already exists, whereas adding that code to your my.conf file is how you prevent it from happening again in the future.