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.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.