Ikhtisar
Keunggulan
Kasus Penggunaan
Database Architecture
Kebijakan Isolasi Sumber Daya
Database Instance
Ketersediaan Tinggi (Beberapa AZ)
Wilayah dan AZ
Failure to Enable Case Insensitivity
Mode fokus
Ukuran font
Issue Description
Failed to enable case insensitivity. An error was reported as follows:
Note:
If the database version is 8.0, you can only choose whether to enable case sensitivity for table names when creating an instance on the purchase page. You cannot modify the
lower_case_table_names parameter after creating the instance.Common Causes
Database or table names contain uppercase letters.
Troubleshooting
Check whether all of the database and table names of the instance are lowercase, convert uppercase names (if any) to lowercase ones, and modify the
lower_case_table_names parameter.Note:
Modifying
lower_case_table_names will cause the database restart.Check if there are uppercase table names
select table_schema,table_name from information_schema.tables where table_schema not in("mysql","information_schema") and (md5(table_name)<>md5(lower(table_name)) or md5(table_schema)<>md5(lower(table_schema)));
Check if there are uppercase database names
select SCHEMA_NAME from information_schema.SCHEMATA where md5(SCHEMA_NAME)<>md5(lower(SCHEMA_NAME));
Bantuan dan Dukungan
Apakah halaman ini membantu?
Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.
masukan