Altova XMLSpy 2024 Enterprise Edition

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

 

ADO Datatype

XML Schema Datatype

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