Data Types for Netezza

The following table lists the data type support for a Netezza database.

The BINARY and VARBINARY data types are not supported for data type definition.

For data source specific information about Netezza data types, see the Netezza database documentation.

Data Types for Netezza
Data Type Definition Keyword1	Netezza Data Type	Description	Data Type Returned
BIGINT	BIGINT	Large signed, exact whole number.	BIGINT
CHAR(n)	CHAR(n)	Fixed-length character string data.	CHAR(n)
DATE	DATE	Date values.	DATE
DECIMAL\|NUMERIC(p,s)	DECIMAL(p,s)	Fixed-point decimal number.	DECIMAL(p,s)
DOUBLE	DOUBLE	Floating-point number.	DOUBLE
FLOAT(p)	FLOAT(p)	64-bit double precision, floating-point number.	FLOAT(p)
INTEGER	INTEGER	Large integer.	INTEGER
NCHAR(n)	NCHAR(n)	Fixed-length Unicode character string.	NCHAR(n)
NVARCHAR(n)	NVARCHAR(n)	Varying-length Unicode character string.	NVARCHAR(n)
REAL	REAL	Floating-point number.	REAL
SMALLINT	SMALLINT	Small integer.	SMALLINT
TIME(p)	TIME(p)	Time value.	TIME(p)
TIMESTAMP(p)	TIMESTAMP(p)	Date and time value.	TIMESTAMP(p)
TINYINT	BYTEINT	Tiny integer.	TINYINT
VARCHAR(n)	VARCHAR(n)	Varying-length character string data.	VARCHAR(n)
1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.