Hosting - Collation problems
Posted: Sat Jan 31, 2009 5:03 pm
I have a PHP/mySQL program developed on a Windows Server that works great on my local server.
When I upload to a hosting service, the SQL Queries return as invalid. After looking through the logs, I've found that the queries that were supposed to be case-insensitive are case-sensitive (hosting service was run linux server). I changed hosting companies to get a Windows Server and encountered the same problem (MySQL Server is on a UNIX socket).
I then called around and found a different hosting company that assured me this would not happen on their service. Guess what.....
Have any of you had the same problem?
What did you do to resolve it? What hosting Company?
What are my alternatives other than going through all the code (over 100 individual pages (many not developed by myself)) to troubleshoot the case-sensitivity?
Thanks in advance for you help.
When I upload to a hosting service, the SQL Queries return as invalid. After looking through the logs, I've found that the queries that were supposed to be case-insensitive are case-sensitive (hosting service was run linux server). I changed hosting companies to get a Windows Server and encountered the same problem (MySQL Server is on a UNIX socket).
I then called around and found a different hosting company that assured me this would not happen on their service. Guess what.....
Have any of you had the same problem?
What did you do to resolve it? What hosting Company?
What are my alternatives other than going through all the code (over 100 individual pages (many not developed by myself)) to troubleshoot the case-sensitivity?
Thanks in advance for you help.