Data Types

The Simba Netezza ODBC Driver supports many common data formats, converting between Netezza data types and SQL data types.

Important:

The maximum size for a record is 65,535 bytes.

The table below lists the supported data type mappings.

Netezza Type	Comment	SQLType
bigint (int8)	Signed	SQL_BIGINT
boolean (bool)	See Return SQL_BIT as 1/0	SQL_BIT
byteint (int1)	Signed	SQL_TINYINT
char(n)	Blank padded Holds latin9 characters n <= 64000	SQL_CHAR
data slice	This is an internal data type.	SQL_SMALLINT
date	Supports BCE dates Year must be between 1 and 9999 inclusive	SQL_TYPE_DATE
decimal(p,s)	Alias for numeric	SQL_NUMERIC
double precision (float8)		SQL_DOUBLE
integer (int4)	Signed	SQL_INTEGER
interval (timespan)	Internally stored as seconds Months are treated as 30 days	SQL_INTERVAL_DAY_TO_SECOND
nchar(n)	Blank padded n <= 16000	SQL_WCHAR
numeric(p, s)	p between 1 and 38 inclusive s between 0 and p inclusive	SQL_NUMERIC
nvarchar(n)	n <= 16000	SQL_WVARCHAR
real (float4)		SQL_REAL
rowid	Internal type Returned as Bigint.	SQL_BIGINT
smallint (int2)	Signed	SQL_SMALLINT
st_geometry(n)	n <= 64000	Not supported
time	Microsecond precision Does not support seconds > 59	SQL_TYPE_TIME
time with timezone	Microsecond precision Time zone must be numeric Offset does not support seconds > 59)	SQL_VARCHAR
timestamp	Microsecond precision Does not support seconds > 59	SQL_TYPE_TIMESTAMP
transaction id	Internal type Returned as Bigint.	SQL_BIGINT
varbinary(n)	n <= 64000 Hex literals use x'FFFF' notation	SQL_VARBINARY
varchar(n)	Holds latin9 characters n <= 64000	SQL_VARCHAR