Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been trying for days to insert data such smileys, data from all languages into mysql through talend.
The source is sql server and target mysql.
If I use the 'Set Names utf8mb4' in mysql and run my insert statements, the data is successfully inserted. (Ex - ハウス, is inserted correctly)
However, if I set the 'Set Names utf8mb4' in additional parameters, it just does not work (ハウス is inserted as ???)
As of now, its tmssqlinput - tmysqlbulkoutputexec
Any idea on how to solve this?
I have gone through the link you have sent me in your previous posts lojdr. But, I couldn't find any solution there
Anyways, thank you for posting your thoughts
There is a post from @rhall where he showed how to transform text from one encoding to another with tJava. Use that.
The problem was with MySQL version. The tmysqlbulkoutputexec works for mysql 5.6 but not the same with 5.7
I guess the handling of utf8 in tmysqlbulkoutputexec is different for mysql 5.6 and 5.7
