About Data Type Mappings for Importing Table Definitions

When importing table definitions, certain data type mappings are supported for use with the Siebel application. The following table contains the data type mappings you can use when importing table definitions.

Supported Data Type	Siebel Data Type
Microsoft SQL Server Data Types
int	Numeric with scale of 0
bigint	Numeric with scale of 0
smallint	Numeric with scale of 0
tinyint	Numeric with scale of 0
float	Numeric
real	Numeric
decimal	Numeric
money	Numeric
smallmoney	Numeric
bit	Numeric with a value of 0 or 1
char	Character
nchar	Character
varchar	Varchar
nvarchar	Varchar
text	Long
ntext	Long
datetime	Date Time
smalldatetime	Date Time
IBM DB2 UDB Data Types
UINT	Numeric with scale of 0
BIGUINT	Numeric with scale of 0
SMALLUINT	Numeric with scale of 0
FLOAT	Numeric
REAL	Numeric
DECIMAL	Numeric
NUMERIC	Numeric
CHAR	Character
VARGRAPHIC	Varchar
LONG VARGRAPHIC	Long
CLOB	CLOB
DATE	Datetime
TIME	Datetime
TIMESTAMP	Datetime
Oracle Database Data Types
Number	Numeric
TIMESTAMP WITH TIME ZONE	Numeric
TIMESTAMP WITH LOCAL TIME ZONE	Numeric
Char	Character
Nchar	Character
varchar2	Varchar
nvarchar2	Varchar
Long	Long
CLOB	CLOB
date	Datetime
Oracle Business Intelligence (BI) Server Data Types
Integer	Numeric with scale of 0
Smallint	Numeric with scale of 0
Tinyint	Numeric with scale of 0
Float	Numeric
Double	Numeric
Bit	Character (1)
Boolean	Character (1)
Char	Character
Varchar	Varchar
Longvarchar	Long
Datetime	Datetime
Date	Datetime
Time	Datetime

The following table contains the data types that are not supported for importing table definitions.

Database	Unsupported Data Types
Microsoft SQL Server	timestamp
	varbinary
	binary
	image
	cursor
	uniqueidentifier
IBM DB2 UDB	DBCLOB
	BLOB
Oracle Database	TIMESTAMP
	NCLOB
	BLOB
	BFILE
	ROWID
	UROWID
	RAW
	LONG RAW
	INTERVAL YEAR TO MONTH
	INTERVAL DAY TO SECOND
Oracle BI Server	Timestamp
	Varbinary
	Longvarbinary
	Binary
	Object
	Unknown