Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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 🙂