Monday 30 October 2017

windows - How to enforce case sensitive table and column names in MySql?

The thing is we are working on windows machine and once
done we deploy the code on unix machine. The code works fine on windows but then in unix
we get the error like 'no such table exists' after changing the table name in correct
case it works fine in unix too. Actually, in windows there is no case sensitive table
names by default but in unix they do have ( read that MySQL tables are actually files
and in unix we have case sensitive file name but not in windows ). Workaround could be
to create all tables again and lets have the table name in lowercase. Yes, we can do
that too, thats fine.



But, still can we impose
case sensitivity on table names in MySql ( windows machine ). If yes, then please let me
know how to do that.

No comments:

Post a Comment

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...