MS Access
Cuando se crea una base de datos MS Access a partir de un esquema XML, los tipos de datos de XML Schema se pasan tipos de datos MS Access, tal y como muestra la tabla que aparece a continuación:
Tipo de datos XML Schema | Tipo de datos 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 | Igual que xs:string |
xs:token | Igual que xs:string |
xs:Name | Igual que xs:string |
xs:NCName | Igual que xs:string |
xs:anyURI | Igual que xs:string |
xs:QName | Igual que xs:string |
xs:NOTATION | Igual que 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 | Igual que 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 | -- sin equivalencia -- |
xs:unsignedShort | -- sin equivalencia -- |
xs:long | -- sin equivalencia -- |
xs:unsignedLong | -- sin equivalencia -- |
xs:byte | Number (Byte) |
xs:unsignedByte | Number (Byte) |