springboot添加用户时显示sql问题

我遇到的问题输入中文显示sql错误

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into users(username,usersex) values(?,?) ]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'username' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'username' at row 1

后面发现将表users的字符型改为utf-8即可。

 ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;