July 26, 2012 at 5:38 am
Hi all,
I'm importing data into DB from xml file. When parsing completes some data in DB have � symbols. DB fileds have nvarchar type.
July 26, 2012 at 6:18 am
anush_tar (7/26/2012)
Hi all,I'm importing data into DB from xml file. When parsing completes some data in DB have ? symbols. DB fileds have nvarchar type.
How are you importing the data ?
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 26, 2012 at 6:21 am
I'm importing like this http://www.sqlservercentral.com/articles/T-SQL/68927/
July 26, 2012 at 6:45 am
anush_tar (7/26/2012)
Ok. Please post the sample data.
However having the field type nvarchar is not enough for unicode characters.
You must precede all unicode string with capital N.
e.g.
DECLARE @STR1 AS NVARCHAR(100)
SET @STR1 = N'?????RHYTHM#'
SELECT @STR1
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply