To add to what Chandu said: XML in SQL supports unicode characters, so you should not have to do anything special to insert Chinese characters. Are you having any difficulties? If you are, it may be because your OS does not have support for it, or because you are using non-unicode strings somewhere along the way (e.g., you should be using NVARCHAR instead of VARCHAR).
DECLARE @EDetails TABLE ( NAME xml ) INSERT INTO @EDetails VALUES(N'?')
UPDATE @EDetails SET NAME = N'<book> <person> <first>???? ÓPCM üñ ¿¡</first> <last>Pai</last> <age>22</age> </person> </book>'
select * from @EDetails
-- Another example declare @x TABLE(col xml ) INSERT INTO @x VALUES( N'<tag>abc</tag>') UPDATE @x set col.modify (N'replace value of (/tag/text())[1] with "?"') select * FROM @x
DECLARE @EDetails TABLE ( NAME xml ) INSERT INTO @EDetails VALUES(N'?')
UPDATE @EDetails SET NAME = N'<book> <person> <first>???? ÓPCM üñ ¿¡</first> <last>Pai</last> <age>22</age> </person> </book>'
select * from @EDetails
-- Another example declare @x TABLE(col xml ) INSERT INTO @x VALUES( N'<tag>abc</tag>') UPDATE @x set col.modify (N'replace value of (/tag/text())[1] with "?"') select * FROM @x
Chinese letters in XML data type(MSSQL)
Posted - 02/21/2013 : 06:39:33
