In version 5.7.25-TiDB-v6.0.0, queries are case-sensitive. If upgraded to the latest version, can it be changed to case-insensitive?

Translated
1

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

Original topic: 5.7.25-TiDB-v6.0.0 版本，搭建的时候区分查询值大小写，如果升级到最新版本可以改为不区分大小写吗？

| username: TiDBer_mvrpvfaN

Version 5.7.25-TiDB-v6.0.0 distinguishes between uppercase and lowercase query values during setup. If upgraded to the latest version, can it be changed to be case-insensitive?

I searched other posts, and it seems that this needs to be specified during setup and cannot be changed afterward. If it can’t be changed, the only option is to rebuild, right?

Why doesn’t the new version of TiDB set case insensitivity as the default?

2
| username: h5n1 | Original post link

The new_collations_enabled_on_first_bootstrap can only be configured during the initial cluster setup. Once the cluster is established, it cannot be changed.

3
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.