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)2
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.
2Due to the ODBC-style interface that is used to communicate with the Netezza server, fractional seconds are lost in the data transfer from server to client.
Last updated: February 23, 2017