XML Parsing - Unable to switch the encoding - Error

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  July 5, 2010 at 9:01 pm

  #220842

  Hi,

  I am getting the following error when I try to parse XML.

  declare @xml xml

  set @xml =

  '[Code]<?xml version="1.0" encoding="utf-16"?>

  <root>

  <names>

  <name>test</name>

  </names>

  <names>

  <name>test1</name>

  </names>

  </root>

  [/Code]

  '

  SELECT

  x.value('name[1]', 'varchar(10)') as Name

  FROM

  @xml.nodes('/root/names') t(x)

  This XML is passed from a C# program.

  This seems to work fine if i change the encoding from utf-16 to utf-8.

  Why does the XM L parser fail with utf-16 as the default encoding?

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  July 6, 2010 at 1:33 am

  #1188953

  Works for me. Remember UTF-16 is similar to UNICODE.

  Please note the N string-prefix.

  declare @xml xml

  set @xml =

  N'<?xml version="1.0" encoding="utf-16"?>

  <root>

  <names>

  <name>test</name>

  </names>

  <names>

  <name>test1</name>

  </names>

  </root>

  '

  SELECT

  x.value('name[1]', 'varchar(10)') as Name

  FROM

  @xml.nodes('/root/names') t(x)

  ---

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

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  July 7, 2010 at 6:40 pm

  #1189939

  Works for me now. Thanks a lot.

  I tried parsing it as nvarchar instead of varchar, but somehow missed to spot N while passing the parameters.

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  March 15, 2013 at 9:01 am

  #1597533

  thanks for the unicode reminder.... N'Was Scratching my head too'