Sybase
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 |