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 ????? ?? ??? ???????. ??????? ??????? ?????? ?? ????? ??????? ??????

• suhailquadri

  SSC Eights!

  Points: 829

  More actions

  April 22, 2013 at 5:44 am

  #1608644

  Declare xml file as this

  declare @ds as xml = N'

  <odds>

  <FIDS>

  <English>???</English>

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

  <Arabic>????? ?? ??? ???????. ??????? ??????? ?????? ?? ????? ??????? ?????? </Arabic>

  </FIDS>

  </odds>'

  Done..

• Abu Dina

  SSChampion

  Points: 14155

  More actions

  April 22, 2013 at 5:55 am

  #1608648

  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