Arabic text is displayed ? reading xml

Question

Post reply

Arabic text is displayed ? reading xml

suhailquadri

SSC Eights!

Points: 829
More actions
April 22, 2013 at 5:18 am

#276800

Hi all,
Please help me as it is very urgent !!
When you paste the below query, it should return arabic text as 3rd column instead it displays "?".. Please help!!
Code:
declare @ds as xml = '
<odds>
<FIDS>
<English>واص</English>
<Location_x002F_Explanation>Operational </Location_x002F_Explanation>
<Arabic>نعتذر عن هذا التأخير. سيبلغكم موظفونا قريباً عن توقيت الاقلاع الجديد </Arabic>
</FIDS>
</odds>'
select x.r.query('English').value('.','nvarchar(max)') as English,
x.r.query(N'Location_x002F_Explanation').value(N'.','nvarchar(max)') as Location,
x.r.value(N'Arabic[1]','nvarchar(max)')
from
@ds.nodes('/odds/FIDS') as x(r)
---------Output ----
EnglishLocation (No column name)
???Operational ????? ?? ??? ???????. ??????? ??????? ?????? ?? ????? ??????? ??????

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

suhailquadri SSC Eights! Points: 829 More actions · Answer 1

Declare xml file as this

declare @ds as xml = N'

<odds>

<FIDS>

<Location_x002F_Explanation>Operational message area - Displayed with the Delayed Status on Gates when there is a new departure time</Location_x002F_Explanation>

</FIDS>

</odds>'

Done..

Abu Dina SSChampion Points: 14155 More actions · Answer 2

Salam, keefak?

You need to change your database collation. I did this on a test database and changed collation to Arabic_100_CI_AS but you may want to choose another collation depending on your needs.

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn