Case sensitive table names with Laragon?
I need to have case sensitive table names in Laragon in order to fix up an older project that has some duplicated tables with different cases.
Adding the following line to my.cnf under [mysqld] does not work:
lower_case_table_names = 2
Can anyone suggest another solution?
As per https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names you should try:
lower_case_table_names = 0
If set to 0, table names are stored as specified and comparisons are case sensitive
If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive
If set to 2, table names are stored as given but compared in lowercase.
And note this:
You should not set lower_case_table_names to 0 if you are running MySQL on a system where the data directory resides on a case-insensitive file system (such as on Windows or OSX)