MS Access
当从XML Schema创建MS Access数据库（DB）时，XML Schema数据类型会被转换为下表中列出的MS Access数据类型。
XML Schema数据类型 | MS Access数据类型 |
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) |