MS Access
Bei Generierung eines XML-Schemas anhand einer MS Access-Datenbank (DB) werden die MS Access DB-Datentypen, wie unten in der Tabelle gezeigt, in XML-Schema-Datentypen konvertiert.
XML-Schema-Datentyp | MS Access-Datentyp |
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) |