utf8mb4 character set on tmysqloutput

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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