用recordset保存的xml文件的问题?
Rs.Save "C:\a.xml", adPersistXML
如果rescordset中含有汉字的记录,则用浏览器打开xml文件时会有错误
用以下语句,也会有错误
Dim oXML As New MSXML2.DOMDocument
oXML.Load "C:\a.xml"
如果xml文件没有汉字则,用浏览器可以查看,用oXML.Load也可以正确把文件读进来.
请问如何解决中文问题??
问题点数:100、回复次数:5Top
1 楼highscore2(谢谢你的回答:p)回复于 2006-03-20 17:28:47 得分 0
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset"
xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly">
<s:AttributeType name="DOCAUTHOR" rs:number="1" rs:nullable="true" rs:maydefer="true">
<s:datatype dt:type="string" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="VPATH" rs:number="2" rs:nullable="true">
<s:datatype dt:type="string" dt:maxLength="260" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="DOCTITLE" rs:number="3" rs:nullable="true" rs:maydefer="true">
<s:datatype dt:type="string" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="FILENAME" rs:number="4" rs:nullable="true">
<s:datatype dt:type="string" dt:maxLength="260" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="PATH" rs:number="5" rs:nullable="true">
<s:datatype dt:type="string" dt:maxLength="260" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="WRITE" rs:number="6" rs:nullable="true">
<s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="SIZE" rs:number="7" rs:nullable="true">
<s:datatype dt:type="i8" dt:maxLength="8" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="RANK" rs:number="8" rs:nullable="true">
<s:datatype dt:type="int" dt:maxLength="4" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="CREATE" rs:number="9" rs:nullable="true">
<s:datatype dt:type="dateTime" rs:dbtype="variantdate" dt:maxLength="16" rs:fixedlength="true" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="CHARACTERIZATION" rs:number="10" rs:nullable="true" rs:maydefer="true">
<s:datatype dt:type="string" rs:maybenull="false"/>
</s:AttributeType>
<s:AttributeType name="DOCCATEGORY" rs:number="11" rs:nullable="true" rs:maydefer="true">
<s:datatype dt:type="string" rs:maybenull="false"/>
</s:AttributeType>
<s:extends type="rs:rowbase"/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row FILENAME="汉字有错误.txt" PATH="f:\temp\汉字有错误.txt" WRITE="2006-02-15T01:35:56" SIZE="20" RANK="128" CREATE="2006-02-15T01:35:31.370000000"/>
<z:row FILENAME="new.txt" PATH="f:\temp\new.txt" WRITE="2006-02-15T01:34:52" SIZE="5" RANK="128" CREATE="2006-02-15T01:34:36.560000000"/>
</rs:data>
</xml>
Top
2 楼highscore2(谢谢你的回答:p)回复于 2006-03-20 17:29:37 得分 0
上面是XML文件格式,如果把
<z:row FILENAME="汉字有错误.txt" PATH="f:\temp\汉字有错误.txt" WRITE="2006-02-15T01:35:56" SIZE="20" RANK="128" CREATE="2006-02-15T01:35:31.370000000"/>
这行不要,则xml能够正常运行.
Top
3 楼highscore2(谢谢你的回答:p)回复于 2006-03-20 22:43:57 得分 0
高手来帮帮忙吧!Top
4 楼gongzhaohui(laoge)回复于 2006-03-21 15:51:43 得分 30
不是高手。参考一下:http://down.dvbbs.net/infoview/Article_2728.htmlTop
5 楼lzheng2001(1加1)回复于 2006-03-22 09:03:14 得分 70
Dim oXML As New MSXML2.DOMDocument
改成
Dim oXML As New MSXML2.DOMDocument4.0
就支持中文的XML文件了
Top




