|
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. | |||