Friday, February 24, 2012

Inserting symbols in field

Hi All,
I am trying to insert symbols in a field of a table.

I am using the datatype nvarchar for the field.
However when i tried to insert a statement with the symbol pi, it comes out as following:
(A) 100? cm2 (B) 140? cm2 (C) 200? cm2

All the pi symbol are converted to ?.

Can ne 1 tell me how i can store such strings in the field.

Thanks

Both the client tool that inserts the symbol AND the client tool that displays the symbol MUST be capable of displaying the symbols. And the symbol for p is not included in the ascii set used by SSMS.

You can store unicode, and you can display unicode -you just can't do it with the SQL Server client tools.

How are you displaying the fields (what application?)

No comments:

Post a Comment