Encoding problem

hiba1 — Sat, 16 Nov 2024 04:54:59 GMT

Hi ,

i extract xml form tsoap and insert data into Microsoft sql server .

this is my job :

the message of tSoap is like :

and this is an exmaple of the xml file response from the tsoap :

<?xml version="1.0" encoding="UTF-8"?>
<envelope>
<header>
<version port="4002" host="ns001tow.netstorming.net">1.6.1</version>
<timestamp>20190817124140</timestamp>
</header>
<response type="countries" product="hotel">
<countries>
<country>
<code value="MW"/>
<names>
<name language="ru" value="МАЛЬТА"/>
<name language="fr" value="MALTE"/>
<name language="en" value="MALTA"/>
<name language="it" value="MALTA"/>
<name language="pt-br" value="MALTA"/>
<name language="es" value="MALTA"/>
</names>
</country>
<country>
<code value="LI"/>
<names>
<name language="ru" value="ЛИТВА"/>
<name language="fr" value="LITUANIE"/>
<name language="en" value="LITHUANIA"/>
<name language="it" value="LITUANIA"/>
<name language="pt-br" value="LITUANIA"/>
<name language="es" value="LITUANIA"/>
</names>
</country>
......

the problem is that the names in russia be like "?" in the DB.

how can i solve this error ?

any help please !!!!

Re: Encoding problem

Anonymous — Wed, 21 Aug 2019 04:43:26 GMT

Hi,

There is a similar post where there was issue due to Chinese characters. Could you please refer below post and use NVARCHAR as the datatype?

https://community.talend.com/t5/Design-and-Development/Handling-special-characters-Japanese-Chinese-to-MSSQL-output/td-p/152119

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

topic Encoding problem in Talend Studio

Encoding problem

Re: Encoding problem