Altova XMLSpy 2023 Professional Edition

当从MS Access数据库(DB)生成XML Schema时,MS Access DB数据类型会被转换为下表中列出的XML Schema数据类型。

 

MS Access数据类型

XML Schema数据类型

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