ADO
当从ADO数据库(DB)生成XML Schema时,ADO DB数据类型会被转换为下表中列出的XML Schema数据类型。
ADO数据类型 | XML Schema数据类型 |
adGUID | xs:ID |
adChar | xs:string |
adWChar | xs:string |
adVarChar | xs:string |
adWVarChar | xs:string |
adLongVarChar | xs:string |
adWLongVarChar | xs:string |
adVarWChar | xs:string |
adBoolean | xs:boolean |
adSingle | xs:float |
adDouble | xs:double |
adNumeric | xs:decimal |
adCurrency | xs:decimal |
adDBTimeStamp | xs:dateTime |
adDate | xs:date |
adBinary | xs:base64Binary |
adVarBinary | xs:base64Binary |
adLongVarBinary | xs:base64Binary |
adInteger | xs:Integer |
adUnsignedInt | xs:unsignedInt |
adSmallInt | xs:short |
adUnsignedSmallInt | xs:unsignedShort |
adBigInt | xs:long |
adUnsignedBigInt | xs:unsignedLong |
adTinyInt | xs:byte |
adUnsignedTinyInt | xs:unsignedByte |