lower_case_table_names

Question

The lower_case_table_names variable according to the documentation, it is allowed to make the change. But in the Azure dashboard it is not possible, the field is disabled. Is there any way to change or when the service starts, put it to start with a different value?

Answer 1

Thanks for your question.

As per below Microsoft document

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations

the lower_case_table_names value can only be set to 1 in Azure Database for MySQL - Flexible Server and it's a static parameter.

MySQL public docs (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names ) says:

It is prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. The restriction is necessary because collations used by various data dictionary table fields are determined by the setting defined when the server is initialized, and restarting the server with a different setting would introduce inconsistencies with respect to how identifiers are ordered and compared.

Thank you!