UTF 8 Encoding with MysqlInput and Context to phpmyadminn

[Anonymous]

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)

[fdenis]

check the db charset.