java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x91\xBD\xF0\x9F…

insert 하려는 컬럼의 캐릭터 셋 문제임

[해결책]

ALTER TABLE `sample`.`address`
CHANGE COLUMN `siDo` `siDo` VARCHAR(20) CHARACTER SET ‘utf8’ NULL DEFAULT NULL ;

해당 컬럼 캐릭터 셋을 UTF8 로 맞추니 해결

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s