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.

For 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