Friday, June 20, 2014

Case sensitive table names in MySQL

In Windows, MySQL database tables are saved with lowercase letters. When you import tables with case sensitive names, these get converted into lowercase names. If you want to maintain case sensitivity in MySQL database, do the following:
  • In your MySQL installation folder, find my.ini file and open it. If you are using xampp, it's usually located in /mysql/bin/ directory.
  • In [mysqld] section, modify the value of lower_case_table_names to 0. If this entry is not there already, simply add this line:
    lower_case_table_names = 0
  • Then restart your MySQL server.

No comments:

Post a Comment