Issue inserting non-Latin characters in a MySQL database

Talend Version (Required)       All versions

Summary

tMysqlOutput is inserting non-Latin characters as ??? characters.
Additional Versions  
Product (Required) Data Integration
Component (Required) Components
Problem Description You are running the Job with the Java property -Dfile.encoding=UTF-8, but the data (with non-Latin characters) is still inserted by tMysqlOutput components as ??? characters in the database.
Problem root cause Either the collation of the table/column and/or the character encoding is not set properly.
Solution or Workaround

To handle non-Latin characters properly, ensure the following:

  1. The table (or column) collation is set to utf8_general_ci or utf8mb4_general_ci.

  2. The AdditionalParams of the tMysqlConnection component are set to characterEncoding=UTF-8.

JIRA ticket number  
Version history
Revision #:
3 of 3
Last update:
‎11-02-2017 03:48 PM
Updated by:
 
Labels (2)
Contributors