XML Parsing - Unable to switch the encoding - SQL Parameter

• TcW_1978

  SSCrazy

  Points: 2018

  More actions

  April 23, 2013 at 11:18 am

  #276813

  I pass an XML parameter from a C# program.

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

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

  I know I can use the N' :

  SET @XMLContent = N'<?xml version="1.0" encoding="utf-16"?><...'

  And then it works fine.

  But I don't set the XML content in SQL, I set it in my C# program.

  Is there a way to convert it to Unicode in the stored procedure?

  Thank you.

• TcW_1978

  SSCrazy

  Points: 2018

  More actions

  April 23, 2013 at 12:17 pm

  #1609219

  Corrected it in the c# program before calling the stored proc.