Problem with nvarchar data with XML in SQL server 2005

Question

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?

Answer 1

It seems to be an encoding problem with your terminal. You may use these commands to have more information on your encoding properties.

sp_helpsort;

SERVERPROPERTY ( collation )

Answer 2

this should help as GABS said :

SELECT SERVERPROPERTY ('collation' )

to see the list of collation and update(mine is Latin1_General_CI_AI)

SELECT * FROM ::fn_helpcollations()