MS Access
When an MS Access database (DB) is created from an XML Schema, the XML Schema datatypes are converted to MS Access datatypes as listed in the table below.
XML Schema Datatype | MS Access Datatype |
xs:ID | GUID |
xs:string | If no facets varchar (255) |
| Size = either length or maxLength |
| If Size <= 255 varchar (n) |
| else memo |
xs:normalizedString | Same as xs:string |
xs:token | Same as xs:string |
xs:Name | Same as xs:string |
xs:NCName | Same as xs:string |
xs:anyURI | Same as xs:string |
xs:QName | Same as xs:string |
xs:NOTATION | Same as xs:string |
xs:boolean | bit |
xs:float | Number (single) |
xs:double | Number (double) |
xs:decimal | Decimal |
xs:duration | Date/Time |
xs:dateTime | Date/Time |
xs:time | Date/Time |
xs:date | Date/Time |
xs:gYearMonth | Date/Time |
xs:gYear | Date/Time |
xs:gMonthDay | Date/Time |
xs:gDay | Date/Time |
xs:gMonth | Date/Time |
xs:hexBinary | If no facets varbinary (255) |
| Size = either length or maxLength |
| If Size <= 8000 varbinary |
| else image (OLE Object) |
xs:base64Binary | Same as xs:hexBinary |
xs:integer | Number (Long Integer) |
xs:int | Number (Long Integer) |
xs:negativeInteger | Number (Long Integer); value constraint |
xs:positiveInteger | Number (Long Integer); value constraint |
xs:nonNegativeInteger | Number (Long Integer); value constraint |
xs:nonPositiveInteger | Number (Long Integer); value constraint |
xs:unsignedInt | Number (Long Integer) |
xs:short | -- no equivalent -- |
xs:unsignedShort | -- no equivalent -- |
xs:long | -- no equivalent -- |
xs:unsignedLong | -- no equivalent -- |
xs:byte | Number (Byte) |
xs:unsignedByte | Number (Byte) |