Monthly Archives: October 2010

XML, UTF-8 and SQL Server

DECLARE @i int DECLARE @XML varchar(300) DECLARE @nXML nvarchar(300) DECLARE @XML_ENCODING varchar(50) DECLARE @XML_BODY nvarchar(250) SET @XML_BODY = N'<X> <TEST text=”Found in XML ®™Âï”/> <TEST text=”Symbols ®™”/> <TEST text=”French àâäèéêëîïôœùûüÇ瀔/> <TEST text=”Spanish ÁÉÍÓÚÑÜáñ¿¡€”/> <TEST text=”German ÄäÖöÜü߀”/> <TEST text=”CYRILLIC ЛЙЖДФЦЭЮЯйфчьыъщ”/> </X>’ … Continue reading

Posted in Uncategorized | Leave a comment