Data Types

INT Type
BOOLEAN Type
TINYINT Type
SMALLINT Type
BIGINT Type
IDENTITY Type
DECIMAL Type
DOUBLE Type
REAL Type
TIME Type
DATE Type
TIMESTAMP Type
BINARY Type
OTHER Type
VARCHAR Type
VARCHAR_IGNORECASE Type
CHAR Type
BLOB Type
CLOB Type
UUID Type
ARRAY Type

INT Type

INT | INTEGER | MEDIUMINT | INT4 | SIGNED

Possible values: -2147483648 to 2147483647

Example:
INT

BOOLEAN Type

BOOLEAN | BIT | BOOL

Possible values: TRUE and FALSE

Example:
BOOLEAN

TINYINT Type

TINYINT

Possible values are: -128 to 127

Example:
TINYINT

SMALLINT Type

SMALLINT | INT2 | YEAR

Possible values: -32768 to 32767

Example:
SMALLINT

BIGINT Type

BIGINT | INT8

Possible values: -9223372036854775808 to 9223372036854775807

Example:
BIGINT

IDENTITY Type

IDENTITY

Auto-Increment value.
Possible values: -9223372036854775808 to 9223372036854775807

Example:
IDENTITY

DECIMAL Type

{DECIMAL | NUMBER | DEC | NUMERIC} ( precisionInt [, scaleInt] )

Data type with fixed precision and scale.
This data type is recommended for storing currency values.

Example:
DECIMAL(20, 2)

DOUBLE Type

{DOUBLE [PRECISION] | FLOAT | FLOAT4 | FLOAT8}

Floating point number (java.lang.Double).
Should not be used to represent currency values, because of rounding problems.

Example:
DOUBLE

REAL Type

REAL

Single precision floating point number (java.lang.Float).
Should not be used to represent currency values, because of rounding problems.

Example:
REAL

TIME Type

TIME

The format is hh:mm:ss.

Example:
TIME

DATE Type

DATE

The format is yyyy-MM-dd.

Example:
DATE

TIMESTAMP Type

{TIMESTAMP | DATETIME | SMALLDATETIME}

The format is yyyy-MM-dd hh:mm:ss[.nnnnnnnnn].

Example:
TIMESTAMP

BINARY Type

{BINARY | VARBINARY | LONGVARBINARY | RAW | BYTEA}
[( precisionInt )]

Represents a byte array. For very long arrays, use BLOB.
There is no maximum precision. The maximum size is the memory available.
For large text data BLOB should be used.

Example:
BINARY(1000)

OTHER Type

OTHER

This type allows storing serialized Java objects. Internally, a byte array is used.
Serialization and deserialization is done on the client side only.
Deserialization is only done get getObject is called.
Java operations cannot be executed inside the database engine for security reasons.
Use PreparedStatement.setObject to store values.

Example:
OTHER

VARCHAR Type

{VARCHAR | LONGVARCHAR |
VARCHAR2 | NVARCHAR | NVARCHAR2 | VARCHAR_CASESENSITIVE}
[( precisionInt )]

Unicode String. Use two single quotes ('') to create a quote.
There is no maximum precision. The maximum size is the memory available.
For large text data CLOB should be used.

Example:
VARCHAR(255)

VARCHAR_IGNORECASE Type

VARCHAR_IGNORECASE [( precisionInt )]

Same as VARCHAR, but not case sensitive when comparing. Stored in mixed case.
There is no maximum precision. The maximum size is the memory available.
For large text data CLOB should be used.

Example:
VARCHAR_IGNORECASE

CHAR Type

{CHAR | CHARACTER | NCHAR}
[( precisionInt )]

This type is supported for compatibility with other databases and older applications.
The difference to VARCHAR is that trailing spaces are ignored.
Unicode String. Use two single quotes ('') to create a quote.
There is no maximum precision. The maximum size is the memory available.
For large text data CLOB should be used.

Example:
CHAR(10)

BLOB Type

{BLOB | TINYBLOB | MEDIUMBLOB | LONGBLOB | IMAGE | OID}
[( precisionInt )]

Like BINARY, but intended for very large values.
Use PreparedStatement.setBinaryStream to store values.

Example:
BLOB

CLOB Type

{CLOB | TINYTEXT | TEXT | MEDIUMTEXT | LONGTEXT | NTEXT | NCLOB}
[( precisionInt )]

Like VARCHAR, but intended for very large values.
Use PreparedStatement.setCharacterStream to store values.

Example:
CLOB

UUID Type

UUID

Universally unique identifier. This is a 128 bit value.
Use PreparedStatement.setBytes or setString to store values.

Example:
UUID

ARRAY Type

ARRAY

An array of values.
Use a value list (1, 2) or PreparedStatement.setObject(.., new Object[]{..}) to store values.

Example:
ARRAY