embulk / embulk/embulk-output-jdbc

Failed to output chinese emoji to mysql

Open
#306 13 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
92
Forks
89
PR merge metrics
No merged PRs in 30d

Description

My mysql uses code utf8mb4, and mysq's temporary table code is utf8mb4,
When I insert data into mysql temporary table, it has the following error:
`org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\xA4\xA3' for column ......`

Can someone help me solve this problem? thanks.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the reported insert of a Chinese emoji into a MySQL utf8mb4 temporary table through the JDBC output plugin, then trace the connection and temporary-table encoding settings involved. Done means the same data inserts without the reported BatchUpdateException, with a regression test covering the emoji case.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.