Database Scope insert not support Chinese

[zj1]

Hello everyone, I’m encountering a problem. The Database Scope insert function doesn’t support Chinese. Are there any solutions for this?

[Anono_Nono]

Does the actual value gets saved to db? Does your db column you are trying to write ti support utf? Is it nvarchar? What db are you using mssql, postgres, depending on that you might need to do some casting.

Also you might want to build you query with String.Format. Those backticks might trip you up:

String.Format(“INSERT INTO data_file (unit) VALUES (N’{0}')”, unit)

It might be that the debugger doesn’t support utf.

[Allan_Zimmermann]

if you go to Open Project tab, what regional settings is the workflow set too ?
Also, some ODBC drivers comes in noth an ANSI and Unicode version, make sure you installed and are using the Unicode driver, if that is the case.

[zj1]

Thank you everyone, it’s been resolved, the issue was with the encoding, and I needed to add this encoding