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