# The pt-table-sync synchronization mysql tinyblob type data error
**URL:** https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954
**Category:** MySQL & MariaDB
**Tags:** mysql
**Created:** [June 11, 2024, 6:12am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954 "2024-06-11T06:12:15Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@yu.wang.gogo](https://forums.percona.com/u/yu.wang.gogo)
#### Post date: [June 11, 2024, 6:12am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/1 "2024-06-11T06:12:16Z")
When I used pt-table-sync to synchronize mysql tinyblob type data, I found that the data on both sides were inconsistent, but there was no error in the log, I accidentally found it, and I could not set the ` - -charset` parameter, see the screenshot for specific results
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [June 12, 2024, 9:55pm UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/2 "2024-06-12T21:55:31Z")
@yu.wang.gogo,
You should be able to use `--charset` and `--set-vars` to enforce the proper character set. If these options are not working, please show us the command you are using and the error output.
---
### Author:  [@yu.wang.gogo](https://forums.percona.com/u/yu.wang.gogo)
#### Post date: [June 17, 2024, 1:21am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/3 "2024-06-17T01:21:17Z")
> [@matthewb](#):
>
> –set-vars
`- -set- -vars` It’s an array parameter, and I don’t really know how to set it up, right?
`--set-vars charset=utf8`
---
### Author:  [@yu.wang.gogo](https://forums.percona.com/u/yu.wang.gogo)
#### Post date: [June 17, 2024, 2:28am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/4 "2024-06-17T02:28:12Z")
My order is as follows：`docker run --network net-db -i -t --rm perconalab/percona-toolkit /usr/bin/pt-archiver --source h=xx.xx.xx.xx,P=3306,u=root,p=Rds-sso-Mysql-01,D=qgbbs,t=post --dest h=mysql,P=3306,u=root,p=fYMF8HabJFWzG6,D=qgbbs,t=post --where "id > 139554432 and id <= 174443040" --bulk-insert --no-delete --limit=4000 --txn-size=4000 --skip-foreign-key-checks --set-vars='character_set_client=utf8,character_set_connection=utf8,character_set_results=utf8' --charset=UTF8 --nosafe-auto-increment --progress=100000 --statistics`
I don t know if my `--set-vars` parameter is added correctly
`--set-vars='character_set_client=utf8,character_set_connection=utf8,character_set_results=utf8'`
But the garbled still exists
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [June 17, 2024, 7:38pm UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/5 "2024-06-17T19:38:27Z")
Can you provide a repeatable test case? Table schema and example data?
---
### Author:  [@yu.wang.gogo](https://forums.percona.com/u/yu.wang.gogo)
#### Post date: [June 18, 2024, 8:21am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/6 "2024-06-18T08:21:50Z")
See the attachment for my table architecture and sample data
[post.txt](https://forums.percona.com/uploads/short-url/c3zRvjFZCoOxWnRDvx7J65wGj4W.txt) (2.6 KB)
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [June 19, 2024, 10:30pm UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/7 "2024-06-19T22:30:50Z")
Running without --bulk-insert worked just fine for me. I keep running into permissions issues when I use --bulk-insert because that requires LOAD INFILE LOCAL privs. Can you try that please?
---
### Author:  [@yu.wang.gogo](https://forums.percona.com/u/yu.wang.gogo)
#### Post date: [June 24, 2024, 6:22am UTC](https://forums.percona.com/t/the-pt-table-sync-synchronization-mysql-tinyblob-type-data-error/30954/8 "2024-06-24T06:22:14Z")
Indeed, if I delete the parameter `--bulk-insert`, I can insert the data normally, and the data is also normal. But my target end open `LOAD INFILE LOCAL`, add `--bulk-insert`, insert can also insert, is the blob field data is not correct, I feel that is a `pt-archiver` in the block data problem