Altova XMLSpy 2023 Professional Edition

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

 

ODBC数据类型

XML Schema数据类型

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