When an XML Schema is generated from a MySQL database (DB), the MySQL DB datatypes are converted to XML Schema datatypes as listed in the table below.
MySQL Datatype |
XML Schema Datatype |
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 |