Engine
Data Types

Data Types

  • Engine type in the one used when defining a table in the DDL.
  • JDBC and ODBC types are shown in the table as a reference in case you are planning to create a new driver/client library.

Engine Type

Description

JDBC type

ODBC type

string or varchar

Variable length character string with a maximum length of 4000.

VARCHAR

VARCHAR

varbinary

Variable length binary string with a nominal maximum length of 8192.

VARBINARY

VARBINARY

char

A single 16 bit character - which cannot represent a value beyond the Basic Multilingual Plane. This limitation also applies to functions/expressions that expect a single character such as trim, textagg, texttable, and like escape.

CHAR

CHAR

boolean

A single bit, or Boolean, that can be true, false, or null (unknown)

BIT

SMALLINT

byte or tinyint

Numeric, integral type, signed 8-bit

TINYINT

SMALLINT

short or smallint

Numeric, integral type, signed 16-bit

SMALLINT

SMALLINT

integer or serial

Numeric, integral type, signed 32-bit. The serial type also implies not null and has an auto-incrementing value that starts at 1. serial types are not automatically UNIQUE.

INTEGER

INTEGER

long or bigint

Numeric, integral type, signed 64-bit

BIGINT

NUMERIC

biginteger

Numeric, integral type, arbitrary precision of up to 1000 digits

NUMERIC

NUMERIC

float or real

Numeric, floating point type, 32-bit IEEE 754 floating-point numbers

REAL

FLOAT

double

Numeric, floating point type, 64-bit IEEE 754 floating-point numbers

DOUBLE

DOUBLE

bigdecimal or decimal

Numeric, floating point type, arbitrary precision of up to 1000 digits.

NUMERIC

NUMERIC

date

Datetime, representing a single day (year, month, day)

DATE

DATE

time

Datetime, representing a single time (hours, minutes, seconds)

TIME

TIME

timestamp

Datetime, representing a single date and time (year, month, day, hours, minutes, seconds, fractional seconds).

TIMESTAMP

TIMESTAMP

object

Any arbitrary serializable object.

JAVA_OBJECT

VARCHAR

blob

Binary large object, representing a stream of bytes.

BLOB

VARCHAR

clob

Character large object, representing a stream of characters.

CLOB

VARCHAR

xml (kept for compatibility but marked for removal)

XML document

JAVA_OBJECT

VARCHAR

geometry

Geospatial Object

BLOB

BLOB

geography

Geospatial Object

BLOB

BLOB

json

Character large object, representing a stream of JSON characters.

CLOB

VARCHAR

Arrays

An array of any type is designated by adding [] for each array dimension to the type declaration.

Example:

string[]

integer[][]

Array handling is typically in memory. It is not advisable to rely on the usage of large array values. Arrays of large objects (LOBs) are typically not handled correctly when serialized.