Altova XMLSpy 2023 Enterprise Edition

当从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)

 

© 2017-2023 Altova GmbH