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. [image] Could you give me some guidance on that? Thanks

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

encoding issue when connecting to Microsoft SQL

ScottF March 18, 2024, 3:32pm 2

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