
snowave
pt-archiver don’t support json type column ?
±—±-----------------+| id | tt |±—±-----------------+| 14 | {“ss”: “哈哈”} |
result of pt-archiver and --file option:
14 {"ss": "åå"}
table :
CREATE TABLE tt1
( id
int(10) unsigned NOT NULL AUTO_INCREMENT, tt
json DEFAULT NULL, PRIMARY KEY (id
)) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8
pt-archiver dsn charset:utf8
| character_set_client | utf8 || character_set_connection | utf8 || character_set_results | utf8 |
| character_set_server | utf8mb4 |