MS Access
Lorsqu'une base de données MS Access (BD) est créée depuis un Schéma XML, les types de données de Schéma XML sont convertis en des types de données de MS Access tels que recensés dans la table ci-dessous.
Type de données Schéma XML | Type de données 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) |