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.