본문 바로가기
WEB,WAS/Spring

oauth2 로그인이 안됨

by Rainbound-IT 2022. 2. 8.
반응형

 

Caused by: java.sql.SQLException: Incorrect string value: '\xEC\xB5\x9C\xED\x98\x84...' for column `springboot_aws`.`user`.`name` at row 1
Query is: insert into user (created_date, modified_date, email, name, picture, role) values (?, ?, ?, ?, ?, ?), parameters ['2020-03-13 02:59:07.699','2020-03-13 02:59:07.699','darren93@naver.com','최현빈',<null>,'GUEST']
java thread: http-nio-8080-exec-6
	at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163) ~[mariadb-java-client-2.3.0.jar!/:na]
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280) ~[mariadb-java-client-2.3.0.jar!/:na]
	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223) ~[mariadb-java-client-2.3.0.jar!/:na]
	... 121 common frames omitted

라는 에러를 발견

 

 

라고 하니까 됨

 

 

ALTER TABLE [테이블이름] CONVERT TO character SET utf8;

반응형

댓글