the tmssqloutput component replaces the korean character from the file with '? ??'

[NNayal1600240775]

Hi my file has data like

when i read this data in tlogrow i can see this korean character. but when write the output to tmssqloutput. i see this character got replaced with

how can i fix this issue

[Anonymous]

Hi

Take a look at this topic and try the suggestions, let me know if it works.

Regards

Shong

[NNayal1600240775 · Accepted solution]

Hi Shong, In my sql table I have set the datatype as "nvarchar" and in Talend tmssqlconnection - in additional jdbc parameter i added ""useUnicode=true;characterEncoding=utf8"". It worked for me.

[Anonymous]

Great, thanks for your feedback and sharing the solution.