# Problem when read data from MSSQL to Node-red

**URL:** <https://discourse.nodered.org/t/problem-when-read-data-from-mssql-to-node-red/71324>\
**Category:** General\
**Created:** [27 November 2022 15:20 UTC](https://discourse.nodered.org/t/problem-when-read-data-from-mssql-to-node-red/71324 "2022-11-27T15:20:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maskmanwithsword](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@maskmanwithsword](https://discourse.nodered.org/u/maskmanwithsword)\
**Post date:** [27 November 2022 15:20 UTC](https://discourse.nodered.org/t/problem-when-read-data-from-mssql-to-node-red/71324/1 "2022-11-27T15:20:58Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/9/39c341d72794feb43b273e39d3ea5b4e7ee7c750.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/8/484f9cd8aa064a3568b29152ef2c51917355d93d.png)

Can someone help me in this?

Thanks!

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [27 November 2022 16:08 UTC](https://discourse.nodered.org/t/problem-when-read-data-from-mssql-to-node-red/71324/2 "2022-11-27T16:08:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [26 January 2023 16:09 UTC](https://discourse.nodered.org/t/problem-when-read-data-from-mssql-to-node-red/71324/3 "2023-01-26T16:09:03Z")

</div>

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