topic Re: Handling special characters(Japanese/Chinese) to MSSQL output in Talend Studio

Handling special characters(Japanese/Chinese) to MSSQL output

Anonymous — Sun, 24 Feb 2019 12:31:02 GMT

I'm still learning how to use talend and its processors,

I have a data set that contains special charaters such as Japanese and Chinese lettering as well as other special characters. i would like to know how i can output those characters in my MSSQL output.

Currently it is populating as question marks.

Thanks in advance

Re: Handling special characters(Japanese/Chinese) to MSSQL output

akumar2301 — Sun, 24 Feb 2019 17:29:01 GMT

before insert in db check if you are able to print these char on console using tlogrow.

if OK ,try NVARCHAR as column type in database.below link will help

https://dba.stackexchange.com/questions/90296/storing-japanese-characters-in-a-table

also check charset of your database table/column , if you can use chinese or japneese char.

Re: Handling special characters(Japanese/Chinese) to MSSQL output

Anonymous — Mon, 25 Feb 2019 04:57:49 GMT

Hi @Shriya ,

@uganesh has given very good point about the DB configuration. You need to setup the DB language and column settings in such a way that it will accept Japanese characters.

One additional point I would like to inform is that lot of Talend components will be expecting the encoding and you need to select UTF-8 wherever it is needed in Talend components to handle Japanese characters.

Example as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂