Updating xml with special characters

• ningaraju.n

  SSCrazy

  Points: 2322

  More actions

  June 8, 2010 at 11:10 pm

  #103946

  Hi All,

  i want to modify an data of xml data type,so i am using

  DECLARE @xml XML

  SET @xml = '<root></root>'

  SET @xml.modify('insert <a>Szövlő</a> into (/root)[1]')

  SELECT @xml

  but the problem is "ő" is not getting stored as it is instead it is getting stored as "o"

  please help me out in this

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  June 11, 2010 at 4:21 am

  #1179077

  See

  http://beyondrelational.com/blogs/jacob/archive/2010/06/09/xquery-lab-56-inserting-elements-with-unicode-values.aspx

  ---

  N 56°04'39.16"
  E 12°55'05.25"