encoding issue when connecting to Microsoft SQL

[ZHZH]

Hi,
I have connected to Microsoft sql using KNIME node.
But I face encoding issue, all the Chinese characters be shown as ‘??’. My database code page is 1252 and column type as varchar.
I have searched some solutions online and set JDBC parameters as below, but it doesn’t work. sendStringParametersAsUnicode=false && sendTimeAsDateTime=false.

Could you give me some guidance on that?
Thanks

[ScottF]

Hi @ZHZH and welcome to the forum.

Can you check one of the topics linked below, and see if it helps you get on the right track:

Special characters when extracting data from database

Hi @gabrielfs2 - This sounds like an encoding issue. You might need to make apply some additional settings in the DB Connector to apply the correct encoding. Here are a few other forum topics dealing with a similar issue: What type of database are you trying to connect to?

[tobias.koetter]

Hello @ZHZH ,
you need to use NVARCHAR not VARCHAR as column type.
Bye
Tobias