embulk / embulk/embulk-output-jdbc
Failed to output chinese emoji to mysql
- 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