When an XML Schema is generated from a Sybase database (DB), the Sybase DB datatypes are converted to XML Schema datatypes as listed in the table below.
Sybase Datatype |
XML Schema Datatype |
char |
xs:string |
nchar |
xs:string |
varchar |
xs:string |
nvarchar |
xs:string |
text |
xs:string |
sysname-varchar(30) |
xs:string |
bit |
xs:boolean |
real |
xs:float |
float |
xs:float |
double |
xs:double |
decimal |
xs:decimal |
money |
xs:decimal |
smallmoney |
xs:decimal |
datetime |
xs:dateTime |
smalldatetime |
xs:dateTime |
timestamp |
xs:dateTime |
binary<=255 |
xs:base64Binary |
varbinary<=255 |
xs:base64Binary |
image |
xs:base64Binary |
integer |
xs:integer |
smallint |
xs:short |
tinyint |
xs:byte |