Interstage Shunsaku Data Manager Application Development Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

12.7 Data Types Supported by the XML Conversion Function

The column data in the results table is expressed using SQL. The SQL types are defined using java.sql.Types.
If the SQL types in the results table are not supported by the XML conversion function, the XML conversion function will report an exception during the conversion process.

Results Table Data Types Compatible with the XML Conversion Function

The following table shows SQL types in the results table that can be used with the XML conversion function.

[Table 12-1 Compatibility of Data Types in the Results Table with the XML Conversion Function]

SQL type in results table	Description	Compatibility
ARRAY	Array object	-
BIGINT	64-bit integer
BINARY (*1)	Fixed-length binary
BIT	1-bit integer
BLOB (*1)	Large binary
CHAR	Fixed-length character string
CLOB	Large character string
DATE	Date
DECIMAL	Decimal
DISTINCT	User-defined type	-
DOUBLE	Double precision floating-point number
FLOAT	Double precision floating-point number
INTEGER	32-bit integer
JAVA_OBJECT	Java-specific object	-
LONGVARBINARY (*1)	Variable-length binary
LONGVARCHAR	Variable-length character string
NULL	Null	-
NUMERIC	Decimal
OTHER	Undefined type	-
REAL	Single precision floating-point number
REF	OID container	-
SMALLINT	16-bit integer
STRUCT	Structure object	-
TIME	Time
TIMESTAMP	Date and time
TINYINT	8-bit integer
VARBINARY (*1)	Variable-length binary
VARCHAR	Variable-length character string

: Represents data types supported
- : Represents data types not supported
*1) binary data

Correspondence between Results Table and Database Data Types

The following table shows the correspondence between the SQL types that can be extracted to the results table and data types used in various databases.

[Table 12-2 Correspondence between SQL Types for Result Table and Database Data Types]

SQL type that can be extracted to results table	Data type in database
	PostgreSQL	Oracle	SQL Server
ARRAY	-	-	-
BIGINT	int8	-	bigint
BINARY	bytea	-	Binary, timestamp
BIT	bool	-	bit
BLOB	-	BLOB	-
CHAR	bpchar	CHAR, NCHAR	Char, nchar, uniqueidentifier
CLOB	-	CLOB, NCLOB	-
DATE	date	DATE	-
DECIMAL	-	-	Smallmoney, money
DISTINCT	-	-	-
DOUBLE	float8, money	-	-
FLOAT	float4	-	-
INTEGER	int4, serial, oid	-	int
JAVA_OBJECT	-	-	-
LONGVARBINARY	-	LONG RAW	image
LONGVARCHAR	-	LONG	Text, ntext
NULL	-	-	-
NUMERIC	Numeric, decimal	NUMBER	numeric
OTHER	-	-	-
REAL	-	-	Real, float(5)
REF	-	-	-
SMALLINT	int2	-	smallint
STRUCT	-	-	-
TIME	time	-	-
TIMESTAMP	Timestamp, timestampz, datetime	TIMESTAMP, TIMESTAMP(6)	Datetime, smalldatetime
TINYINT	-	-	tinyint
VARBINARY	-	RAW	varbinary
VARCHAR	Text, varchar, lztext	VARCHAR2, NVARCHAR	Varchar, nvarchar, sql_variant

- : Represents data types not supported