# Percona Toolkit v3.5.7 Released

**URL:** https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394
**Category:** Percona Toolkit
**Tags:** new-release
**Created:** [December 25, 2023, 1:53pm UTC](https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394 "2023-12-25T13:53:22Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Aleksandra\_Abramova](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aleksandra_abramova/32/3038_2.png) [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)
#### Post date: [December 25, 2023, 1:53pm UTC](https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394/1 "2023-12-25T13:53:22Z")

</div>

December 23, 2023 - Find release notes at [Percona Toolkit — Percona Toolkit Documentation](https://docs.percona.com/percona-toolkit/release_notes.html#v3-5-7-released-2023-12-23)

---

<div class="post-metadata">

### Author: ![hetao](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hetao/32/16359_2.png) [@hetao](https://forums.percona.com/u/hetao)
#### Post date: [May 9, 2024, 8:53am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-7-released/27394/2 "2024-05-09T08:53:48Z")

</div>

The json filed type content with wrong encode type：

The table define:

```sql
CREATE TABLE `t_article` (
  `pk_article` bigint NOT NULL AUTO_INCREMENT,
  `topics` json DEFAULT NULL ,
  `title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL ,
  PRIMARY KEY (`pk_article`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ;

```

The Mysql Version: 8.0.28, 8.4.0

The source:

```bash
+------------+--------------------------------------+---------------------------+
| pk_article | topics | title |
+------------+--------------------------------------+---------------------------+
| 74 | ["中国", "美国", "China", "USA"] | 测试中文 test Chinese |
+------------+--------------------------------------+---------------------------+

```

The Dst:

```bash
+------------+--------------------------------------------------+---------------------------+
| pk_article | topics | title |
+------------+--------------------------------------------------+---------------------------+
| 74 | ["ä¸å›½", "美国", "China", "USA"] | 测试中文 test Chinese |
+------------+--------------------------------------------------+---------------------------+

```

The Command:

```bash
pt-table-sync --verbose --execute --databases test h=127.0.0.1,P=6446,u=root,p=h=127.0.0.1,P=3401,u=root,p=

```

The Variables:

```bash
+--------------------------+------------------------------+
| Variable_name | Value |
+--------------------------+------------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /data/mysql8/share/charsets/ |
+--------------------------+------------------------------+

```