MS Access
When an XML Schema is generated from an MS Access database (DB), the MS Access DB datatypes are converted to XML Schema datatypes as listed in the table below.
MS Access Datatype | XML Schema Datatype |
GUID | xs:ID |
char | xs:string |
varchar | xs:string |
memo | xs:string |
bit | xs:boolean |
Number(single) | xs:float |
Number(double) | xs:double |
Decimal | xs:decimal |
Currency | xs:decimal |
Date/Time | xs:dateTime |
Number(Long Integer) | xs:integer |
Number(Integer) | xs:short |
Number(Byte) | xs:byte |
OLE Object | xs:base64Binary |