有关sp_xml_preparedocument使用
DECLARE @hdoc int
DECLARE @doc varchar(2000)
SET @doc = '<result><data d001="2003-10-22 17:08:58" t001="重量" t002="-999" t003="速度" t004="-999" t005="动能" t006="-999"/></result>'
exec sp_xml_preparedocument @hDoc OUTPUT,@doc
运行时，报错
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 33
XML parsing error: An Invalid character was found in text content.
但如果将中文字符改为英文字符可以。请问中文字符怎么办？
问题点数：100、回复次数：1Top
1 楼pengdali（）回复于 2003-11-04 13:58:11 得分 100
DECLARE @hdoc int
DECLARE @doc varchar(2000)
SET @doc = '<?xml version="1.0" encoding="GB2312"?> <result><data d001="2003-10-22 17:08:58" t001="重量" t002="-999" t003="速度" t004="-999" t005="动能" t006="-999"/></result>'
exec sp_xml_preparedocument @hDoc OUTPUT,@docTop
