MS Access

www.altova.com Dieses Kapitel drucken Vorherige Seite Eine Ebene nach oben Nächste Seite

Startseite >  Anhänge > Datentypen in DB, die anhand von XML-Schemas generiert wurden >

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)

 


© 2019 Altova GmbH