Altova XMLSpy 2024 Enterprise Edition

When an XML Schema is generated from an MS Access database (DB), the MS Access DB datatypes are converted to XML Schema datatypes as listed in the table below.

 

MS Access Datatype

XML Schema Datatype

GUID

xs:ID

char

xs:string

varchar

xs:string

memo

xs:string

bit

xs:boolean

Number(single)

xs:float

Number(double)

xs:double

Decimal

xs:decimal

Currency

xs:decimal

Date/Time

xs:dateTime

Number(Long Integer)

xs:integer

Number(Integer)

xs:short

Number(Byte)

xs:byte

OLE Object

xs:base64Binary

 

© 2017-2023 Altova GmbH