Help Center> Relational Database Service> FAQs> Database Parameter Modification> How Do I Set Case Sensitivity for RDS MySQL Table Names?
How Do I Set Case Sensitivity for RDS MySQL Table Names?
For existing DB instances, 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. Figure 1 Database configuration
- 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.
Parent topic: Database Parameter Modification
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.