IBM InfoSphere Federation Server, Version 10.5

Default forward data type mappings for Microsoft SQL Server data sources

The following table lists the default forward data type mappings for Microsoft SQL Server data sources.

Note: The remote typenames for Microsoft SQL Server are case sensitive.

Table 1. Microsoft SQL Server default forward data type mappings
Remote Typename	Remote Lower Len	Remote Upper Len	Remote Lower Scale	Remote Upper Scale	Remote Bit Data	Remote Data Operators	Federated Typename	Federated Length	Federated Scale	Federated Bit Data
bigint	-	-	-	-	-	-	BIGINT	-	-	-
binary	1	254	-	-	-	-	CHARACTER	-	-	Y
binary	255	8000	-	-	-	-	VARCHAR	-	-	Y
bit	-	-	-	-	-	-	SMALLINT	2	-	-
char	1	254	-	-	-	-	CHAR	-	-	N
char	255	8000	-	-	-	-	VARCHAR	-	-	N
datetime	-	-	-	-	-	-	TIMESTAMP(6)	10	6	-
datetime2	19	27	0	7	-	-	TIMESTAMP	-	-	-
decimal	1	31	0	31	-	-	DECIMAL	-	-	-
decimal	32	38	0	38	-	-	DOUBLE	-	-	-
float	-	8	-	-	-	-	DOUBLE	8	-	-
float	-	4	-	-	-	-	REAL	4	-	-
image	-	-	-	-	-	-	BLOB	2147483647	-	Y
int	-	-	-	-	-	-	INTEGER	4	-	-
money	-	-	-	-	-	-	DECIMAL	19	4	-
nchar	1	127	-	-	-	-	CHAR	-	-	N
nchar	128	4000	-	-	-	-	VARCHAR	-	-	N
numeric	1	31	0	31	-	-	DECIMAL	-	-	-
numeric	32	38	0	38	-	-	DOUBLE	8	-	-
ntext	-	-	-	-	-	-	CLOB	2147483647	-	Y
nvarchar	1	4000	-	-	-	-	VARCHAR	-	-	N
real	-	-	-	-	-	-	REAL	4	-	-
smallint	-	-	-	-	-	-	SMALLINT	2	-	-
smalldatetime	-	-	-	-	-	-	TIMESTAMP(6)	10	6	-
smallmoney	-	-	-	-	-	-	DECIMAL	10	4	-
SQL_BIGINT*	-	-	-	-	-	-	BIGINT	-	-	-
SQL_BINARY*	1	254	-	-	-	-	CHARACTER	-	-	Y
SQL_BINARY*	255	8000	-	-	-	-	VARCHAR	-	-	Y
SQL_BIT*	-	-	-	-	-	-	SMALLINT	2	-	-
SQL_CHAR*	1	254	-	-	-	-	CHAR	-	-	N
SQL_CHAR*	255	8000	-	-	-	-	VARCHAR	-	-	N
SQL_DATE*	-	-	-	-	-	-	DATE	4	-	-
SQL_DECIMAL*	1	31	0	31	-	-	DECIMAL	-	-	-
SQL_DECIMAL*	32	38	0	38	-	-	DOUBLE	8	-	-
SQL_DOUBLE*	-	-	-	-	-	-	DOUBLE	8	-	-
SQL_FLOAT*	-	-	-	-	-	-	DOUBLE	8	-	-
SQL_GUID*	-	-	-	-	-	-	VARCHAR	-	-	Y
SQL_INTEGER*	-	-	-	-	-	-	INTEGER	4	-	-
SQL_ LONGVARCHAR*	-	-	-	-	-	-	CLOB	2147483647	-	N
SQL_ LONGVARBINARY*	-	-	-	-	-	-	BLOB	-	-	Y
SQL_NUMERIC*	1	31	0	31	-	-	DECIMAL	-	-	-
SQL_NUMERIC*	32	38	0	38	-	-	DOUBLE	8	-	-
SQL_REAL*	-	-	-	-	-	-	REAL	8	-	-
SQL_SMALLINT*	-	-	-	-	-	-	SMALLINT	2	-	-
SQL_TIME*	-	-	-	-	-	-	TIME	3	-	-
SQL_TIMESTAMP*	-	-	-	-	-	-	TIMESTAMP	10	6	-
SQL_TINYINT*	-	-	-	-	-	-	SMALLINT	2	-	-
SQL_VARBINARY*	1	8000	-	-	-	-	VARCHAR	-	-	Y
SQL_VARCHAR*	1	8000	-	-	-	-	VARCHAR	-	-	N
SQL_WCHAR*	1	254	-	-	-	-	CHARACTER	-	-	N
SQL_WCHAR*	255	8800	-	-	-	-	VARCHAR	-	-	N
SQL_WLONGVARCHAR*	-	1073741823	-	-	-	-	CLOB	2147483647	-	N
SQL_WVARCHAR*	1	16336	-	-	-	-	VARCHAR	-	-	N

text	-	-	-	-	-	-	CLOB	-	-	N
timestamp	-	-	-	-	-	-	VARCHAR	8		Y
tinyint	-	-	-	-	-	-	SMALLINT	2	-	-
uniqueidentifier	1	4000	-	-	Y	-	VARCHAR	16	-	Y
varbinary	1	8000	-	-	-	-	VARCHAR	-	-	Y
varchar	1	8000	-	-	-	-	VARCHAR	-	-	N
* You cannot use this data type in the `type-mapping-name` clause of the CREATE TYPE MAPPING statement.

Feedback