TiDB utf8mb4

Translated
1

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

Original topic: TIDB utf8mb4

| username: MSGJC

Version 6.1.0
Currently in the production environment, it is necessary to enable new_collations_enabled_on_first_bootstrap. Is there a way to enable it dynamically?

2
| username: 啦啦啦啦啦 | Original post link

It only takes effect during the initial cluster setup. Currently, there is no method for dynamic adjustment; you can only rebuild and synchronize the setup. However, it should be enabled by default in version 6.1, right?

3
| username: MSGJC | Original post link

Error: [ddl:1273]Unsupported collation when new collation is enabled: ‘utf8mb4_0900_ai_ci’

4
| username: 啦啦啦啦啦 | Original post link

Is the data synchronized from version 8.0? Currently, utf8mb4_0900_ai_ci is not supported.

5
| username: MSGJC | Original post link

The error message indicates that the system cannot find the specified file. This is usually caused by an incorrect file path or the file not existing. Please check if the file path is correct and if the file exists.

6
| username: MSGJC | Original post link

Restored after BR backup

7
| username: alfred | Original post link

The utf8mb4_0900_ai_ci collation is rarely used.

8
| username: 特雷西-迈克-格雷迪 | Original post link

Currently, only utf8mb4_unicode_cn is supported.