UTF 8 Encoding with MysqlInput and Context to phpmyadminn

Anonymous — Wed, 06 Jun 2018 14:09:55 GMT

Hello everyone

I would like to encode in Encoding UTF8 in all my tMysqlOutput because in my phpMyAdmin, all column are in UTF8 but all characters in data with accents (é, è, à, ...) are replace by "?".

So, i change in advanced settings (tMysqlInput, tMysqlOutput) with a context and i tried :

-noDatetimeStringSync=true&useUnicode=true&characterEncoding=UTF-8

-noDatetimeStringSync=true&SET character_set_results = 'utf8'

-noDatetimeStringSync=true& character_set_client = 'utf8',

-noDatetimeStringSync=true& character_set_connection = 'utf8'

-noDatetimeStringSync=true&, character_set_database = 'utf8'

-noDatetimeStringSync=true& character_set_server = 'utf8'"

in the context which has been in advanced settings MysqlOutput.

And it doesn't seem to work.

Now i don't know how to resolve that.

Thank you for your help!

Beauchamp_J

(Talend version : 6.5.1)

Re: UTF 8 Encoding with MysqlInput and Context to phpmyadminn

fdenis — Fri, 08 Jun 2018 12:55:21 GMT

check the db charset.

topic UTF 8 Encoding with MysqlInput and Context to phpmyadminn in Talend Studio

UTF 8 Encoding with MysqlInput and Context to phpmyadminn

Re: UTF 8 Encoding with MysqlInput and Context to phpmyadminn