Altova XMLSpy 2024 Professional Edition

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

 

ODBC Datatype

XML Schema Datatype

SQL_GUID

xs:ID

SQL_CHAR

xs:string

SQL_VARCHAR

xs:string

SQL_LONGVARCHAR

xs:string

SQL_BIT

xs:boolean

SQL_REAL

xs:float

SQL_DOUBLE

xs:double

SQL_DECIMAL

xs:decimal

SQL_TIMESTAMP

xs:dateTime

SQL_DATE

xs:date

SQL_BINARY

xs:base64Binary

SQL_VARBINARY

xs:base64Binary

SQL_LONGVARBINARY

xs:base64Binary

SQL_INTEGER

xs:integer

SQL_SMALLINT

xs:short

SQL_BIGINT

xs:long

SQL_TINYINT

xs:byte

 

© 2017-2023 Altova GmbH