Case sensitive table names with Laragon?


  • | 395 points

    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?

    Thank you...


  • | 2644 points

    @cristo

    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)


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.