Windows VS Linux Server

Hi all,

I use windows and Xampp as my development environment. I can run my dolphin app smoothly locally. But when i upload it to my host, which runs on linux, the problem begins to show. It seems that windows is NOT CASE SENSITIVE and linux is.

the table `localizedlanguages` is from the dump file i made from my local mySql database.

the query that the app is trying to run is: SELECT `ID` FROM `LocalizationLanguages` WHERE `NAME` = 'en-us'

my host do not seem to recognize `LocalizationLanguages` even though it has a table named `localizationlanguages`

With that my question is,

Is there a way to turn off case sensitivity in phpMyAdmin?

-OR-

Is there a way to implement an 'all lower case sql statement' in dolphin?

Please let me know.

Thank you very much

Check lower_case_table_names system variable in linux.

Usually in unix like systems it is set to 0 and windows it is set to 1.

Thanks okweb. will try that later and keep you posted

Windows VS Linux.

No Comparison.

Linux Kicks ASS. And windows............................

Well...........................

It just sucks............................