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;

posted @ 2022-11-10 00:28  没有烦恼的猫猫  阅读(53)  评论(0)    收藏  举报