Case sensitive table names with Laragon?

  • | 532 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...

  • | 4363 points


    As per 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.