Help Center > > 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?

Updated at: Jun 09, 2021 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel