Hi, I’m trying to use DB writer to write table into sql server database. Some of my columns are in string with Chinese character, DB writing by mapping string to varchar is ok, but the Chinese charater is displayed like ??? in varchar format. I tried to map string to nvarchar, the DB writer reported “String or binary data would be truncated” error. In the past when I was using the legacy database writer node to write string containing Chinese character in nvarchar format, everything is good. So the question is: Is there a way to set the length of the nvarchar format? I searched the error code, looks like it is caused by inserting data into a string column while the data size is more than the column size. Probably above is not the real cause? Any idea on how to solve this? Appreciate your kind suggestion thanks Xiaoan

"String or binary data would be truncated" error with DB Writer node

ipazin March 24, 2020, 2:24pm 3

Hi there @XXA,

there is difference between old and new database framework regarding character length
Think these topics might help you:

Br,
Ivan

1 Like