MS Access データベース (DB) が XML スキーマから生成される場合、 MS Access データ型は下のテーブルの通り XML スキーマデータ型に変換されます。
XML スキーマ データ型 |
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) |
