# pt-archiver - Character set mismatch

**URL:** https://forums.percona.com/t/pt-archiver-character-set-mismatch/6303
**Category:** Percona Toolkit
**Created:** [April 16, 2018, 3:55am UTC](https://forums.percona.com/t/pt-archiver-character-set-mismatch/6303 "2018-04-16T03:55:34Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![fabi](https://avatars.discourse-cdn.com/v4/letter/f/22d042/32.png) [@fabi](https://forums.percona.com/u/fabi)
#### Post date: [April 16, 2018, 3:55am UTC](https://forums.percona.com/t/pt-archiver-character-set-mismatch/6303/1 "2018-04-16T03:55:34Z")

</div>

I am using pt-archiver 3.0.8 (3.0.8-1.stretch) on Debian 9 “Stretch” with mariaDB (10.1.26-0+deb9u1). When using this command:

I am running in the following issue:

The character set seems the same on source and destination.  
dbserver.example.local

> select \* from information\_schema.schemata;  
> ±-------------±-------------------±---------------------------±-----------------------±---------+  
> | CATALOG\_NAME | SCHEMA\_NAME | DEFAULT\_CHARACTER\_SET\_NAME | DEFAULT\_COLLATION\_NAME | SQL\_PATH |  
> ±-------------±-------------------±---------------------------±-----------------------±---------+  
> | def | fabitest | latin1 | latin1\_swedish\_ci | NULL |  
> | def | information\_schema | utf8 | utf8\_general\_ci | NULL |  
> | def | mysql | utf8mb4 | utf8mb4\_general\_ci | NULL |  
> | def | performance\_schema | utf8 | utf8\_general\_ci | NULL |  
> ±-------------±-------------------±---------------------------±-----------------------±---------+

:

> select \* from information\_schema.schemata;  
> ±-------------±-------------------±---------------------------±-----------------------±---------+  
> | CATALOG\_NAME | SCHEMA\_NAME | DEFAULT\_CHARACTER\_SET\_NAME | DEFAULT\_COLLATION\_NAME | SQL\_PATH |  
> ±-------------±-------------------±---------------------------±-----------------------±---------+  
> | def | fabitestarchive | latin1 | latin1\_swedish\_ci | NULL |  
> | def | information\_schema | utf8 | utf8\_general\_ci | NULL |  
> | def | mysql | utf8mb4 | utf8mb4\_general\_ci | NULL |  
> | def | performance\_schema | utf8 | utf8\_general\_ci | NULL |  
> ±-------------±-------------------±---------------------------±-----------------------±---------+

Can somebody explain how pt-archiver checks the character set?  
I used pt-archiver on Debian 8 but with mysql. After upgrading my script isn’t working anymore.

Thanks