Table of Contents

Search

  1. Preface
  2. Web Services
  3. SOAP Web Services
  4. WSDL Data Object
  5. Schema Object
  6. How to Create a SOAP Web Service
  7. Operation Mappings
  8. Parsing Web Service SOAP Messages
  9. Generating Web Service SOAP Messages
  10. Web Service Consumer Transformation
  11. REST Web Services
  12. How to Create a REST Web Service
  13. REST Web Service Consumer Transformation
  14. REST and SOAP Web Service Administration
  15. Datatype Compatibility

Web Services Guide

Web Services Guide

XML and Transformation Datatypes

XML and Transformation Datatypes

XML datatypes map to transformation datatypes that the Data Integration Service uses to move data across platforms.
The Data Integration Service supports all XML datatypes specified in the W3C May 2, 2001 Recommendation. However, the Data Integration Service may not support the entire XML value range. For more information about XML datatypes, see the W3C specifications for XML datatypes at the following location: http://www.w3.org/TR/xmlschema-2.
The following table compares XML datatypes to transformation datatypes:
Datatype
Transformation
Range
anyURI
String
1 to 104,857,600 characters
base64Binary
Binary
1 to 104,857,600 bytes
boolean
String
1 to 104,857,600 characters
byte
Integer
-2,147,483,648 to 2,147,483,647
date
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
dateTime
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
decimal
Decimal
Precision 1 to 28, scale 0 to 28
double
Double
Precision of 15 digits
duration
String
1 to 104,857,600 characters
ENTITIES
String
1 to 104,857,600 characters
ENTITY
String
1 to 104,857,600 characters
float
Double
Precision of 15 digits
gDay
String
1 to 104,857,600 characters
gMonth
String
1 to 104,857,600 characters
gMonthDay
String
1 to 104,857,600 characters
gYear
String
1 to 104,857,600 characters
gYearMonth
String
1 to 104,857,600 characters
hexBinary
Binary
1 to 104,857,600 bytes
ID
String
1 to 104,857,600 characters
IDREF
String
1 to 104,857,600 characters
IDREFS
String
1 to 104,857,600 characters
int
Integer
-2,147,483,648 to 2,147,483,647
integer
Integer
-2,147,483,648 to 2,147,483,647
language
String
1 to 104,857,600 characters
long
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Name
String
1 to 104,857,600 characters
NCName
String
1 to 104,857,600 characters
negativeInteger
Integer
-2,147,483,648 to 2,147,483,647
NMTOKEN
String
1 to 104,857,600 characters
NMTOKENS
String
1 to 104,857,600 characters
nonNegativeInteger
Integer
-2,147,483,648 to 2,147,483,647
nonPositiveInteger
Integer
-2,147,483,648 to 2,147,483,647
normalizedString
String
1 to 104,857,600 characters
NOTATION
String
1 to 104,857,600 characters
positiveInteger
Integer
-2,147,483,648 to 2,147,483,647
QName
String
1 to 104,857,600 characters
short
Integer
-2,147,483,648 to 2,147,483,647
string
String
1 to 104,857,600 characters
time
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
token
String
1 to 104,857,600 characters
unsignedByte
Integer
-2,147,483,648 to 2,147,483,647
unsignedInt
Integer
-2,147,483,648 to 2,147,483,647
unsignedLong
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
unsignedShort
Integer
-2,147,483,648 to 2,147,483,647