Altova XMLSpy 2024 Enterprise Edition

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

 

MySQL数据类型

XML Schema数据类型

char

xs:string

varchar

xs:string

text

xs:string

tinytext

xs:string

mediumtext

xs:string

longtext

xs:string

tinyint(1)

xs:boolean

float

xs:float

double

xs:double

decimal

xs:decimal

datetime

xs:dateTime

blob

xs:base64Binary

tinyblob

xs:base64Binary

mediumblob

xs:base64Binary

longblob

xs:base64Binary

smallint

xs:short

bigint

xs:long

tinyint

xs:byte

 

© 2017-2023 Altova GmbH