Altova XMLSpy 2024 Professional Edition

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

 

ADO数据类型

XML Schema数据类型

adGUID

xs:ID

adChar

xs:string

adWChar

xs:string

adVarChar

xs:string

adWVarChar

xs:string

adLongVarChar

xs:string

adWLongVarChar

xs:string

adVarWChar

xs:string

adBoolean

xs:boolean

adSingle

xs:float

adDouble

xs:double

adNumeric

xs:decimal

adCurrency

xs:decimal

adDBTimeStamp

xs:dateTime

adDate

xs:date

adBinary

xs:base64Binary

adVarBinary

xs:base64Binary

adLongVarBinary

xs:base64Binary

adInteger

xs:Integer

adUnsignedInt

xs:unsignedInt

adSmallInt

xs:short

adUnsignedSmallInt

xs:unsignedShort

adBigInt

xs:long

adUnsignedBigInt

xs:unsignedLong

adTinyInt

xs:byte

adUnsignedTinyInt

xs:unsignedByte

 

© 2017-2023 Altova GmbH