[Case Sensitivity Configuration] TiDB Version 8.1, Case Sensitivity Configuration

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【大小写敏感配置】TiDB V8.1版本,大小写敏感配置

| username: Acdante

【TiDB Usage Environment】Testing
【TiDB Version】8.1.0
【Reproduction Path】Case sensitivity configuration
【Encountered Problem】Need to adjust case sensitivity. During initial deployment, case sensitivity was not emphasized. Currently, need to adjust the configuration to change to case sensitivity.
【Resource Configuration】
Current parameter configuration:

| username: Defined2014 | Original post link

Without enabling the new collation, there’s no way around it; you’ll have to start over from scratch.