Explore the different datatype to catalog datatype mappings available for the datasource.
- Default mapping
The tables lists the mapping from datatype to catalog datatype, making data management simpler and more organized.
Table 1. Datatype Catalog datatype Bigint BIGINT Binary Binary Blob Blob Char Char Char for Bit Data BINARY Clob CLOB Date DATE or TIMESTAMP DBClob CLOB or NCLOB Decfloat DECIMAL Decimal DECIMAL Double DOUBLE Float DOUBLE Graphic CHAR or NCHAR Integer INTEGER Long Varchar LONGVARCHAR Long Varchar for Bit Data LONGVARBINARY Long Vargraphic LONGVARCHAR or LONGNVARCHAR Numeric NUMERIC Real REAL Rowid VARBINARY Smallint SMALLINT Time TIME Timestamp TIMESTAMP Timestamp with Time Zone VARCHAR or TIMESTAMP Varbinary VARBINARY Varchar VARCHAR Varchar for Bit Data VARBINARY Vargraphic VARCHAR or NVARCHAR XML CLOB or SQLXML - Advanced connectivity bundle mapping
The mapping from datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used. For configuration details, refer Advanced connector bundle.
Table 2. Datatype Catalog datatype BIGINT integer BINARY blob BINARY LARGE OBJECT blob BINARY VARYING blob BLOB blob CHAR string CHAR LARGE OBJECT string CHAR VARYING string CHARACTER string CHARACTER LARGE OBJECT string CHARACTER VARYING string CLOB string DATALINK string DATE date DB2XML.XMLCLOB string DB2XML.XMLFILE string DB2XML.XMLVARCHAR string DBCLOB string DEC decimal DECFLOAT decimal DECIMAL decimal DOUBLE double DOUBLE PRECISION double FLOAT double GRAPHIC string INT integer INTEGER integer LONG VARCHAR string LONG VARGRAPHIC string NUMERIC decimal REAL decimal ROWID integer SMALLINT integer TIME time TIMESTAMP datetime TIMESTAMP WITH TIME ZONE datetime TIMESTAMP WITHOUT TIME ZONE datetime VARBINARY blob VARCHAR string VARGRAPHIC string XML string