SOAP-to-ASE datatype mappings

The following table shows SOAP datatypes and their corresponding types in Adaptive Server Enterprise. These are used when mapping RPC/encoded Web services to proxy tables in Adaptive Server Enterprise.

SOAP datatype	Adaptive Server Enterprise datatype
string	varchar – Length depends on Adaptive Server Enterprise page size
boolean	smallint
float	real
double	double precision
decimal	float
duration	datetime
dateTime	datetime
time	datetime
date	datetime
gYearMonth	datetime
gYear	datetime
gMonthDay	datetime
gDay	datetime
gMonth	datetime
hexBinary	Unsupported
base64Binary	Unsupported
anyURI	varchar – length depends on Adaptive Server Enterprise page size
QName	varchar – length depends on Adaptive Server Enterprise page size
NOTATION	varchar – length depends on Adaptive Server Enterprise page size
normalizedString	varchar – length depends on Adaptive Server Enterprise page size
token	varchar – length depends on Adaptive Server Enterprise page size
language	varchar – length depends on Adaptive Server Enterprise page size
NMTOKEN	varchar – length depends on Adaptive Server Enterprise page size
Name	varchar – length depends on Adaptive Server Enterprise page size
NCName	varchar – length depends on Adaptive Server Enterprise page size
ID	varchar – length depends on Adaptive Server Enterprise page size
IDREF	varchar – length depends on Adaptive Server Enterprise page size
ENTITY	varchar – length depends on Adaptive Server Enterprise page size
integer	integer
nonPositiveInteger	integer
negativeInteger	integer
long	integer
int	integer
short	smallint
byte	tinyint
nonNegativeInteger	integer
unsignedLong	integer
unsignedInt	integer
unsignedShort	smallint
unsignedByte	tinyint
positiveInteger	integer
soap arrays	Not supported
soap complex datatypes	Not supported