The special character changed to question mark in DB

  • Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol. I am passing an xml via stored procedure and i checked with query profiler the input is delta only, but after insert or update its converted to question mark symbol 🙁

    Please anyone give me a hand..

  • You see the question mark where? in an app? in SSMS? Use the UNICODE function to inspect the actual numeric value.

    SELECT UNICODE(LEFT(YourField,1)) FROM TABLE

    I think the ASCI code for a question mark is 63. If you see any other number, it's not a question mark in the database - you're just seeing that.

  • yuvakom (9/30/2013)


    Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol...

    What is the datatype of destination column ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • The short answer is that varchar columns don't get along with Unicode characters. Your column type should be nvarchar.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply