ASE-to-SOAP datatype mappings for the create service command

The following table defines the relationship between datatypes available as a type to a stored procedure and the datatype used for a SOAP user-defined Web service.

NoteFor a Web service accessed through the HTTP GET method, which corresponds to Web services of type http or raw, all parameters are mapped to a type of xsd:string.

Table C-2: SOAP and Adaptive Server Enterprise datatypes

ASE datatype

SOAP parameter type

tinyint

xsd:int

smallint

xsd:int

int

xsd:int

bigint

xsd:decimal

numeric (p,s)

xsd:decimal

decimal (p,s)

xsd:decimal

float (precision)

xsd:float

double (precision)

xsd:double

real

xsd:double

smallmoney

xsd:int

money

xsd:int

smalldatetime

xsd:datetime

datetime

xsd:datetime

date

xsd:datetime

time

xsd:datetime

char(n)

xsd:string

varchar(n)

xsd:string

unichar

xsd:string

univarchar

xsd:string

nchar

xsd:string

nvarchar

xsd:string

binary

xsd:byte[]

varbinary

xsd:byte[]

xml

xsd:string

text

Not supported

image

Not supported

Java Data Type

Not supported