首页 > 数据库 >mysql字符集插入中文报错

mysql字符集插入中文报错

时间:2022-11-10 00:33:31浏览次数:49  
标签:java name error 字符集 报错 user mysql ###

org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE5\x8B\x87' for column 'user_name' at row 1
### The error may exist in com/mao/userInfo/mapper/UserMapper.java (best guess)
### The error may involve com.mao.userInfo.mapper.UserMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO all_user  ( id, user_name, user_password,    create_time, update_time )  VALUES  ( ?, ?, ?,    ?, ? )
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x8B\x87' for column 'user_name' at row 1

ALTER TABLE 表名 CONVERT TO CHARACTER SET utf8;

标签:java,name,error,字符集,报错,user,mysql,###
From: https://www.cnblogs.com/maomao777/p/16875704.html

相关文章