UTF 8 Encoding with MysqlInput and Context to phpmyadminn

Seven Stars

UTF 8 Encoding with MysqlInput and Context to phpmyadminn

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)

Eleven Stars

Re: UTF 8 Encoding with MysqlInput and Context to phpmyadminn

check the db charset.

Francois Denis

Tag as "solved" for others! Kudos to thanks!