Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The special character changed to question mark in DB Expand / Collapse
Author
Message
Posted Monday, September 30, 2013 1:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 14, 2013 4:06 AM
Points: 1, Visits: 4
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..
Post #1499878
Posted Monday, September 30, 2013 5:49 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 178, Visits: 565
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.
Post #1500227
Posted Thursday, October 3, 2013 2:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
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
Post #1501042
Posted Friday, October 4, 2013 9:45 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 384, Visits: 1,512
The short answer is that varchar columns don't get along with Unicode characters. Your column type should be nvarchar.
Post #1501654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse