When importing data with tidb-lightning, an unknown utf8mb3 error is prompted

Translated
1

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

Original topic: tidb-lightning导入数据，提示未知的utf8mb3

| username: 清风Jack

[Test Environment for TiDB] Testing
[TiDB Version] v6.5.1
[Reproduction Path] tidb-lightning --config tidb-lightning.toml, using Physical Import Mode for import
[Encountered Issue: Phenomenon and Impact] Error “Unknown character set: ‘utf8mb3’” when importing data exported from MySQL to TiDB
[Resource Configuration] 4c 8g, single cluster testing
[Attachment: Screenshot/Log/Monitoring]

image
image1380×76 26.6 KB

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

Refer to this post. It is recommended to change the character set of the upstream table to a character set supported by TiDB.

3
| username: tidb菜鸟一只 | Original post link

TiDB does not support the utf8mb3 character set, it is recommended to modify it.

4
| username: xingzhenxiang | Original post link

Find the corresponding SQL file and modify the character set to utfmb4 to see if it works.