encoding issue when connecting to Microsoft SQL

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

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:

1 Like

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

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.