How Do I Set Case Sensitivity for RDS MySQL Table Names?
For the RDS for MySQL 8.0 DB instances you have created, the case sensitivity for table names cannot be modified.
You can set the case sensitivity for table names during the DB instance creation using either of the following methods. Currently, only MySQL 8.0 supports case sensitivity settings for table names.
- Set Table Name Case Sensitivity on the RDS console by referring to Buying a DB Instance.
- Set lower_case_table_names by invoking an API to create a DB instance by referring to Creating a DB Instance.Value range:
- 0: Table names are fixed and case sensitive.
- 1: Table names are stored in lowercase and are case insensitive.