Data getting trimmed in gridField

Question

Hi, 
 
 I have some data in my DB which contains spaces in between, but when I am trying to display same data using a!gridTextColumn that data is getting trimmed. 
 For e.g. I have data as "abc *** 89" in DB but when I am displaying on form it is getting displayed as "abc *** 89" 
 I am not using trim function anywhere while displaying data. 
 
 Any suggestions to handle the above scenario. 
 Thanks in advance. 
 
 Regards, 
 Trunal Jain (TJ)

Alok Patro · Answer

I am using 17.1v and for me the data is coming fine as per the input in the database.. Even tried with abc *** 89 ... 
 
May be some browser issue.

aloks0189 · Answer

HI TJ as per my understanding, this is not something which is getting cause due to Appian or it's versions, in fact the Web Browsers 
plays a major role in these cases, and Appian has nothing to do with this. 
 
Usually Web Browsers replaces multiple spaces with the single one. For best example: If you have MySQL Cloud DB Access through Web Browser, try inserting/updating a row having multiple spaces as it's value, let's assume "a b" when you save the data, you will find the browser shows only once space between a & b i.e. "a b" (which is not the actual data), but when you edit the same data through SQL Browser / fetch the same using Appian, you are going to see the actual data (including multiple spaces). 
 
However did you try executing Query Entity directly(without interface), is that returning multiple white-spaces? If yes, can you try printing your datasubset as label or instructions of the form. 
 
However i recommend, you can try to have validations (if applicable) to avoid these possibilities of capturing & storing white-spaces.