Appendix C: SOAP and Adaptive Server Enterprise Datatype Mapping  Glossary

Appendix C: SOAP and Adaptive Server Enterprise Datatype Mapping

Datatype mapping

The following table shows SOAP datatypes and their corresponding types in Adaptive Server Enterprise.

Table C-1: SOAP and Adaptive Server Enterprise datatypes

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

The following table lists datatype conversions between Java, SOAP, and Adaptive Server Enterprise using the Apache Axis toolkit.

Table C-2: Java, SOAP, and ASE datatypes

Java datatype

SOAP datatype

ASE datatype

byte

xsd:base64binary

image

boolean

xsd:boolean

int

byte

xsd:byte

Char (1)

java.util.Calendar

xsd:dateTime

datetime

java.math.BigDecimal

xsd:decimal

Numeric

double

xsd:double

float(8)

float

xsd:float

float

int

xsd:int

int

java.math.BigInteger

xsd:integer

numeric(38,0)

long

xsd:long

float (8)

javax.xml.namespace.Qname

xsd:Qname

varchar(pagesize)

short

xsd:short

short

java.lang.String

xsd:string

varchar(pagesize)





Copyright © 2004. Sybase Inc. All rights reserved. Glossary

View this book as PDF