How Do I Set Case Sensitivity for GaussDB(for MySQL) Table Names?

You can specify case sensitivity for table names when creating an instance on the console or using APIs. It cannot be changed after the instance is created.

• Set Table Name Case Sensitivity on the console.
  Figure 1 Configuring case sensitivity for table names
  
• Set lower_case_table_names by invoking an API.
  Value range:

  • 0: Table names are case sensitive.
  • 1 (default value): Table names are stored in lowercase and are case insensitive.