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 |