topic Re: utf8mb4 character set on tmysqloutput in Talend Studio

utf8mb4 character set on tmysqloutput

Anonymous — Wed, 04 May 2016 08:59:47 GMT

Hi guys,
I just want to ask if it's possible to set the character encoding of tmysqloutput to utf8mb4 to insert unicode characters other than the earlier emojis and characters?
I'm extracting data from twitter using stream but I'm getting errors on the tweet with those unicode characters.
I've tried adding "noDatetimeStringSync=true&characterEncoding=UTF-8" on the additional JDBC parameters and also added on the Job Run VM Arguments "-Dfile.encoding=UTF-8" but i've researched that what I needed to do is to set the character encoding to utf8mb4 but it gives me an error of "java.sql.SQLException: Unsupported character encoding 'utf8mb4'."
Can someone help me please. Thanks.

Re: utf8mb4 character set on tmysqloutput

Anonymous — Wed, 04 May 2016 09:22:54 GMT

I have not tried this with Talend; but here's a useful article which may provide some assistance.
https://mathiasbynens.be/notes/mysql-utf8mb4

Re: utf8mb4 character set on tmysqloutput

Anonymous — Thu, 05 May 2016 03:39:24 GMT

Thanks for the reply! I've tried setting the character encoding of the schema, table and column as what the link says. Still can't read the other characters.

Re: utf8mb4 character set on tmysqloutput

Anonymous — Thu, 05 May 2016 04:20:06 GMT

Attached is the screenshot of the error. By the way, I'm using custom components for twitter extraction from this site