Issues with Data Import and Export

Translated
1

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

Original topic: br 导入导出数据问题。

| username: ffeenn

[Test Environment for TiDB] Testing
[TiDB Version] 6.5.0
[Encountered Issue: Problem Description and Impact]
Upgraded from 5.4.1 to 6.5.0, exported data using br, and restored to 6.5.0

[Attachment: Screenshot/Logs/Monitoring]
Error Screenshot

image
image1637×178 15.6 KB

2
| username: db_user | Original post link

There should still be some differences between different versions, but this error is related to collation. Did you enable the new collation parameter in your original cluster? Also, compare the sql_mode to see if they are consistent.

3
| username: hey-hoho | Original post link

Did the cluster have the new_collations_enabled_on_first_bootstrap parameter enabled before the upgrade?

The error message indicates that TiDB does not support your Latin1_swedish_ci collation.

4
| username: ffeenn | Original post link

Does this also have to do with sql_mode?

5
| username: ffeenn | Original post link

The collations should be consistent, and the old version did not use the Latin1_swedish_ci collation.

6
| username: ffeenn | Original post link

The default database collation is utf8mb4_general_ci.

7
| username: ffeenn | Original post link

I did a screening, and some automatically generated specific tables have this kind of sorting. Let me modify the sorting and try again.

8
| username: system | Original post link

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