Unanswered: mySQL and Case Sensitive Table Name issue
I am new to mySQL and I have having issue with table name being case sensitive. How can I disable this option when I issue SQL Statement. My Local server works fine, but when i use same code with my hosting server I get error...that table not found. If I change table name in exact CASE as actual table name then it will be fine..Coming from MS SQL environment...this is kind of annoying to have table name in SQL statement as case sensitive..
I do not think I can ask my hosting company to turn this off since they must be hosting to another clients as well..So only option I see is in my connection string or somewhere else if I can turn this off
Don't see the problem. Use all upper case or all lower case when you name your tables. stick to that naming convention at all times. then you know that you will either use all upper or all lower in your scripts or any time you reference the tables.