1、Mysql如果编码为:
mysql> show variables like 'char%';
+--------------------------+-----------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /apps/mysql/share/charsets/ |
+--------------------------+-----------------------------+
8 rows in set (0.04 sec)
那么在JMeter这边通常无法插入中文:
Incorrect string value: '\x85\x85????...' for column 'c1' at row 1
服务端需要修改:
mysql> set names 'gbk';
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'char%';
+--------------------------+-----------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /apps/mysql/share/charsets/ |
+--------------------------+-----------------------------+
8 rows in set (0.00 sec)
2、JMeter JDBC定义的连接池URL需要增加参数:characterEncoding=UTF-8
另外,mysql表的编码查询方法:
show full columns from xxx;