A
aylm
Unregistered / Unconfirmed
GUEST, unregistred user!
我在使用oracle 中遇到一个郁闷的问题.<br>TClientDataSet.xmlData的使用过程中,发现对于有的版本的oracle数据库在处理number类型字段数据时xmlData中的数据类型被保存为Fixed类型,但是数据并没有取到.但是对于其它版本的oracle数据库就没有问题.数据类型为r8<br>Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit<br><?xml version="1.0" standalone="yes"?> <DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="USERID" fieldtype="fixed" DECIMALS="4" WIDTH="255"/><FIELD attrname="USERNO" fieldtype="string.uni" WIDTH="20"/><FIELD attrname="USERNAME" fieldtype="string.uni" WIDTH="60"/><FIELD attrname="LIMITID" fieldtype="fixed" DECIMALS="4" WIDTH="255"/><FIELD attrname="USERPASSWORD" fieldtype="string.uni" WIDTH="60"/><FIELD attrname="COMPANYID" fieldtype="fixed" DECIMALS="4" WIDTH="255"/><FIELD attrname="PHONENUMBER" fieldtype="string.uni" WIDTH="26"/><FIELD attrname="ROLEID" fieldtype="string.uni" WIDTH="2048"/><FIELD attrname="ALTERID" fieldtype="fixed" DECIMALS="4" WIDTH="255"/></FIELDS><PARAMS/></METADATA><ROWDATA><ROW USERID="" USERNO="fmer" USERNAME="&#26446;&#26126;" LIMITID="" USERPASSWORD="8997A880D065" COMPANYID="" PHONENUMBER="1234567" ROLEID="100" ALTERID=""/></ROWDATA></DATAPACKET><br><br>Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit <br><?xml version="1.0" standalone="yes"?> <DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="USERID" fieldtype="r8"/><FIELD attrname="USERNO" fieldtype="string.uni" WIDTH="20"/><FIELD attrname="USERNAME" fieldtype="string.uni" WIDTH="60"/><FIELD attrname="LIMITID" fieldtype="r8"/><FIELD attrname="USERPASSWORD" fieldtype="string.uni" WIDTH="60"/><FIELD attrname="COMPANYID" fieldtype="r8"/><FIELD attrname="PHONENUMBER" fieldtype="string.uni" WIDTH="26"/><FIELD attrname="ROLEID" fieldtype="string.uni" WIDTH="2048"/><FIELD attrname="ALTERID" fieldtype="r8"/></FIELDS><PARAMS/></METADATA><ROWDATA><ROW USERID="21" USERNO="fmer" USERNAME="&#26446;&#26126;" LIMITID="99" USERPASSWORD="8997A880D065" COMPANYID="3" PHONENUMBER="1234567" ROLEID="100" ALTERID="31"/></ROWDATA></DATAPACKET><br>?