How to Solve the Issue of Newly Added Base64 Encoding for JSON After Upgrading TiDB

Translated
1

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

Original topic: tidb 升级之后json新增base64 编码如何解决

| username: TiDBer_yyy

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.1.0
Data Synchronization Link: mysql → dm → tidb

After upgrading TiDB, JSON strings are encrypted into base64:type253

image
image1380×282 130 KB

Related post: 升级至6.5.3版本之后，JSON列类型出现base64:type253编码 - TiDB 的问答社区

Could the experts kindly provide a specific solution?

How to quickly resolve this?

2
| username: Billmay表妹 | Original post link

Take a look at the solution in the best answer.

3
| username: Billmay表妹 | Original post link

The image you uploaded is not visible. Please provide the text you need translated.

4
| username: Fly-bird | Original post link

My cousin is awesome.

5
| username: Kongdom | Original post link

So, was it resolved in the end? The related post has already been marked with the best answer.

6
| username: ajin0514 | Original post link

So how do we solve it?

7
| username: zhanggame1 | Original post link

I didn’t understand how it was resolved.

8
| username: 像风一样的男子 | Original post link

Can someone summarize how to solve this problem?

9
| username: ajin0514 | Original post link

Upgrade to version 7

10
| username: TiDBer_yyy | Original post link

Upgrade the DM cluster to 7.1

11
| username: system | Original post link

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