mysql 字符集入库失败,mysql字符集汉字入库时出错

数据入库出错提示：java.sql.SQLException: Incorrect string value: ‘\xE7\x94\xB7’ for column ‘sex’ at row 1

使用 show variables like ‘character%’ 查看数据库的编码，果然是latin1，意料之中。

mysql> show variables like ‘character%’;

±-------------------------±--------------------------------------+

| 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 | C:\mysql-5.7.18-win32\share\charsets\ |

±-------------------------±--------------------------------------+

8 rows in set, 1 warning (0.03 sec)

mysql> alert database tuanplus charactr set utf8;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near ‘alert

database tuanplus charactr set utf8’ at line 1

set character_set_database=utf8

mysql> set character_set_results=utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_server=utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_connection=utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_client=utf8;

Query OK, 0 rows affected (0.01 sec)

mysql> show variables like ‘character%’;

±-------------------------±--------------------------------------+

| Variable_name | Value |

±-------------------------±--------------------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | C:\mysql-5.7.18-win32\share\charsets\ |

±-------------------------±--------------------------------------+

8 rows in set, 1 warning (0.00 sec)

但重启mysql服务后，又还原了，得添加my.ini文件。然后再重启。

标签：set,字符集,utf8,character,rows,sec,mysql,入库

来源： https://blog.csdn.net/matrixbbs/article/details/90370165