java.sql.SQLException:?Incorrect?string?value:?'\xF0\x9F\x92\x94'?for?colum?n?'name'?at?row?1?at?com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)?
at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)?
at?com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)?
at?com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)?
at?com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)?
at?com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)?
at?com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)?
at?com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)

? ??? ???? Java ?? ? ??????? ?? ???? ???? ? ????. . ???? ?? ???? ???? ???? ???? ???.

??? ???? ??????? ??? ? ???? ??? ?? ??? ?? ?????.

mysql ?????? ?? ? ?? ??? UTF-8? ?? ??? java??? ???? ???? ??? ??? ? ?? ??? ?????. (?? ?? WeChat? ??? ???? ?? ?? ??? ? ?? ???? ???? ???? ???? ?????.)

?? ?????. UTF-8 ???? 2???, 3??? ?? 4???? ? ??? ? ? Emoji ??? 4????? MySQL? UTF-8 ???? ?? 3?????? ???? ??? ? ????. .
???:
1. ?????? ???? ?????(MySQL? utf8mb4 ?? 5.5.3 ??? ????? ?? ???? ??????? ?)
??:
(1. ??????, ??? ?? , ? ?? ??

ALTER?DATABASE?database_name?CHARACTER?SET?=?utf8mb4?COLLATE?=?utf8mb4_unicode_ci;ALTER?TABLE?table_name?CONVERT?TO?CHARACTER?SET?utf8mb4?COLLATE?utf8mb4_unicode_ci;ALTER?TABLE?table_name?CHANGE?column_name?VARCHAR(191)?CHARACTER?SET?utf8mb4?COLLATE?utf8mb4_unicode_ci;

(2. mysql ?? ?? my.cnf ??(?? my.ini)

[client]
default-character-set?=?utf8mb4
[mysql]
default-character-set?=?utf8mb4
[mysqld]
character-set-client-handshake?=?FALSE
character-set-server?=?utf8mb4
collation-server?=?utf8mb4_unicode_ci
init_connect='SET?NAMES?utf8mb4'

(3. Java ??? ???? ?? ???????? mysql ?? ??? 5.1.13 ???? ?????. ??? ??? ??? utf8mb4? ??? ? ????
(4. ??? db ?? ??

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=utf8&autoReconnect=true&rewriteBatchedStatements=TRUE
jdbc.username=root
jdbc.password=password

mysql-connector? ??????? CharacterEncoding=utf8? ??? ? ????. utf8mb4(?? utf8? ??)? ?? ????
autoReconnection(?????? ??? ?????? ???? ???? ?? ?????? ???? false???) ? ??? ???? ?? ??? ??? ? ????. ??> ?? DB? ?? ??? utf8mb4 ?? ??? ??? ? ????.

2. ???? ?? ?, ??? ????? ???? ?? ??????.

URLEncoder.encode(nickName,?"utf-8");

???????? ???? ??? ??? ?? ??????.

URLDecoder.decode(nickname,?"utf-8");

?????? ????? ??? ??? ? ?? getter, setter ????? ?? ????? ?? ?? ????. ???? setter ???? ??? ?? ? ???? ????? ?????. ??????? ??? ? ???? getter ???? ???? ??? ???? ?? ????. ?? ???? ?? setter?? ???? Nickname? ?? ?????? ?? ??? ?? ?????. ??>

? ?? mysql ?? ???? ??(WeChat ?? ??? ??..) ??? ??? PHP ??? ????? ????