field value displays different

[basbrian]

I am working on a laboratory database and I am having trouble with a field displaying differently. when I run a select with "result to grid" the field displays as an arrow pointing north, an "o", a vertical line with a small hypen out the middle on the right side and a "C". in result to text mode it displays as a square, a small o, a box and a "C". the field is varchar(50).
I am trying to print the field as the value as displayed in the "result to grid" format in a sql server reporting services report. how can I make this happen.
this is the field using a copy oC

 

[philhege]

You have four characters in this field, the first and third of which are non-printing control characters. In order to print them in a Web page, you'll have to find the ASCII/code page equivalents, or a representation that is agreeable to your users. Firefox is interpreting these characters as 18 and 19. The display for each in HTML-encoded format is  and 
but you'll see the same result. I'm not sure what code page you're using in SSMS to get graphical characters to display. I get the same funky square box in my Studio.

-----------
With business clients like mine, you'd be better off herding cats.

 

[philhege]

Actually the numbers are Unicode, so the characters are the Cancel and End-of_Medium codes.

-----------
With business clients like mine, you'd be better off herding cats.