after moving site sql query error because of database case sensitive issues
Permalink
Hi,
basically i moved from wamp to host gater, and it looks like all the tables in the database i exported are lower case yet the sql queries are looking for capitalized tables which now don't exist because the server is case sensitive.
Is there an easy way to get around this problem? no idea why it all isn't the same case to begin with. Any help would be great.
Regards,
Dean
basically i moved from wamp to host gater, and it looks like all the tables in the database i exported are lower case yet the sql queries are looking for capitalized tables which now don't exist because the server is case sensitive.
Is there an easy way to get around this problem? no idea why it all isn't the same case to begin with. Any help would be great.
Regards,
Dean
Think this deals with that although I have not tried it personally.