Wednesday, 4 May 2016

mysql : make mysql db to be case sensitive for queries

In my mysql db, i have a table called customer



In my local test environment mysql db, I can do select * from Customer but when my code is rolled out to a production environment for clients to use, select * from customer throws syntax error.




This is because the production environment mysql db is case sensitive.



How do i change my local enviorement mysql to be case sensitive?



Thanks!

No comments:

Post a Comment