Hosting - Collation problems

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
iridium617
Forum Newbie
Posts: 1
Joined: Sat Jan 31, 2009 4:40 pm

Hosting - Collation problems

Post by iridium617 »

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.
Post Reply