SQL Query fields change to uppercase on upload to server.
- by Conor H
Hi There,
I have just finished developing an app using CodeIgniter. When I upload it to my Host (Hostgator shared) some of the SQL text is converted to uppercase and rendering the app unusable.
In my database I have two tables client and transaction. When I upload the App to the server client and transaction is replaced with all caps. Obviously this is bad as MySQL queries are case sensitive.
At first I was uploading with FTP and thought FTP was to blame. I then zipped up the app and uploaded the archive, unpacking it on the server shell. Still no joy.
Any ideas on how to fix this? At the moment I just have to go into the server and edit my queries back to lowercase..
Cheers in advance for any ideas..
--Conor