Problem when read data from MSSQL to Node-red

General
1

Hi all,

I'm having a problem when I read data from MSSQL to Node-red, it has a space after the data i've read.
image

image

Can someone help me in this?

Thanks!

2

You have probably set the field to CHAR(20) or similar. You will either need to use varchar or trim the strings.

1 Like
3

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