Encoding problem

[hiba1]

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 !!!! 

[Anonymous · Accepted solution]

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-...

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