Help Center/ TaurusDB/ FAQs/ Database Parameter Modification/ How Do I Set Case Sensitivity for TaurusDB Table Names?
Updated on 2025-04-22 GMT+08:00

How Do I Set Case Sensitivity for TaurusDB Table Names?

You can specify case sensitivity for table names when creating an instance on the console or using APIs.

The case sensitivity of table names for created instances cannot be changed. lower_case_table_names can only be set during server initialization. It cannot be changed once the server has been initialized. For details, see MySQL 8.0 documentation.

  • Set Table Name to Case sensitive or Case insensitive on the TaurusDB console during instance creation.
    Figure 1 Setting case sensitivity for table names

  • Set lower_case_table_names by invoking an API. For details, see Creating a DB Instance.
    Value range:
    • 0: Table names are case sensitive.
    • 1 (default value): Table names are stored in lowercase and are case insensitive.