space in column data

[Ananda Vardhan]

I have data like this in a column
"Test Sample "
Spaces between test and sample words and after sample. When i retrieve this in a multiline textbox it displays small squares for spaces which is weird.

[Rabbit]

That means they're not spaces. They are unprintable characters and different programs display them in different ways.

[arie]

As @Rabbit said, they're probably not spaces. Find out what those characters are

char strangeChar = '?'; 
int charcode = strangechar; // decimal code of character '?'

(here's the ascii table: http://www.asciitable.com/), and replace them before displying

textToDisplay = yourString.Replace (oldchar, newchar);