Problem when convert to NVARCHAR(MAX) while creating XML file from XML column in php

• gurmeet.singla

  Newbie

  Points: 7

  More actions

  February 24, 2009 at 12:14 pm

  #72686

  Hi,

  I am working on a problem which includes SQL server 2005, XML, PHP and accented characters. I am working on this from few days and could not able to find the reason. It will be great if you guys can help me in this.

  I have a XML column in a table and this contains accented characters also. I need to create a xml file from this this XML data from XML column. When I try to convert XML column data into NVARCHAR(MAX), it corrupts the accented characters and does not produce any XML.

  Thanks

  Gurmeet