Altova XMLSpy 2024 Enterprise Edition

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

 

© 2017-2023 Altova GmbH