ADO
When an XML Schema is generated from an ADO database (DB), the ADO DB datatypes are converted to XML Schema datatypes as listed in the table below.
ADO Datatype | XML Schema Datatype |
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 |