The special character changed to question mark in DB

• yuvakom

  SSC Veteran

  Points: 207

  More actions

  September 30, 2013 at 1:43 am

  #298420

  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..

• nick.mcdermaid

  Hall of Fame

  Points: 3809

  More actions

  September 30, 2013 at 5:49 pm

  #1654743

  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.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  October 3, 2013 at 2:02 am

  #1655435

  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;-)

• sqldriver

  SSChampion

  Points: 10440

  More actions

  October 4, 2013 at 9:45 am

  #1655947

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