Problem with nvarchar data with XML in SQL server 2005

Posted by Paresh on Stack Overflow See other posts from Stack Overflow or by Paresh
Published on 2010-05-20T13:29:33Z Indexed on 2010/05/20 18:10 UTC
Read the original article Hit count: 301

Filed under:
|
|
|
Create table testxml
(xmldata xml)

declare @var nvarchar(max)
set @var = N'?????? ?????? ????'

insert into testxml
select @var 

After inserting , i am getting data from table like

select * from testxml
---------------------
????????

Can you provide me the solution?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server