Domain interface

Describes the Domain object type information for a column in a table.

Syntax

public interface Domain

Members

All members of the Domain interface, including all inherited members.

Name	Description
BIG variable	Denotes the domain ID constant for a 64-bit integer (BIGINT SQL type).
BINARY variable	Denotes the domain ID constant for a variable-length binary object of maximum size bytes (BINARY(size) SQL type).
BIT variable	Denotes the domain ID constant for a bit (BIT SQL type).
DATE variable	Denotes the domain ID constant for a Date (DATE SQL type).
DOMAIN_MAX variable	Denotes the maximum kinds of Domain types.
DOUBLE variable	Denotes the domain ID constant for a 8-byte floating point (DOUBLE SQL type).
INTEGER variable	Denotes the domain ID constant for a 32-bit integer (INTEGER SQL type).
LONGBINARY variable	Denotes the domain ID constant for an arbitrary long block of binary data (BLOB) (LONG BINARY SQL type).
LONGBINARYFILE variable	Denotes the domain ID constant for an arbitrary file of data.
LONGVARCHAR variable	Denotes the domain ID constant for an arbitrary long block of character data (CLOB) (LONG VARCHAR SQL type).
NUMERIC variable	Denotes the domain ID constant for a numeric value of fixed precision (size) total digits and with scale digits after the decimal (NUMERIC(precision,scale) SQL type).
REAL variable	Denotes the domain ID constant for a 4-byte floating point (REAL SQL type).
SHORT variable	Denotes the domain ID constant for a 16-bit integer (SMALLINT SQL type).
ST_GEOMETRY variable	Denotes the denotes the domain ID constant for a geometry (GEOMETRY SQL type)
TIME variable	Denotes the domain ID constant for a Time (TIME SQL type).
TIMESTAMP variable	Denotes the domain ID constant for a Timestamp (TIMESTAMP SQL type).
TIMESTAMP_ZONE variable	Denotes the domain ID constant for a timestamps with time zones (DATETIMEOFFSET SQL type).
TINY variable	Denotes the domain ID constant for a unsigned 8-bit integer (TINYINT SQL type).
UNSIGNED_BIG variable	Denotes the domain ID constant for a unsigned 64-bit integer (UNSIGNED BIGINT SQL type).
UNSIGNED_INTEGER variable	Denotes the domain ID constant for a unsigned 32-bit integer (UNSIGNED INTEGER SQL type).
UNSIGNED_SHORT variable	Denotes the domain ID constant for a unsigned 16-bit integer (UNSIGNED SMALLINT SQL type).
UUID variable	Denotes the domain ID constant for a UniqueIdentifier (UNIQUEIDENTIFIER SQL type).
VARCHAR variable	Denotes the domain ID constant for a variable-length character string of maximum size bytes (VARCHAR(size) SQL type).

Remarks

This interface contains constants to denote the various domains, and methods that extract information from a Domain object.

See the Connection interface for an example of creating a schema for a simple database.

Types can be classified as follows:

Integer Types:

Domain Constant	SQL Type	Value Range
BIT	BIT	0 or 1
TINY	TINYINT	0 to 255 (unsigned integer using 1 byte of storage)
SHORT	SMALLINT	-32768 to 32767 (signed integer using 2 bytes of storage)
UNSIGNED_SHORT	UNSIGNED SMALLINT	0 to 65535 (unsigned integer using 2 bytes of storage)
INTEGER	INTEGER	-2³¹ to 2³¹ - 1, or -2147483648 to 2147483647 (signed integer using 4 bytes of storage)
UNSIGNED_INTEGER	UNSIGNED INTEGER	0 to 2³² - 1, or 0 to 4294967295 (unsigned integer using 4 bytes of storage)
BIG	BIGINT	-2⁶³ to 2⁶³ - 1, or -9223372036854775808 to 9223372036854775807 (signed integer using 8 bytes of storage)
UNSIGNED_BIG	UNSIGNED BIGINT	0 to 2⁶⁴ - 1, or 0 to 18446744073709551615 (unsigned integer using 8 bytes of storage)

Non-Integer Numeric Types:

Domain Constant	SQL Type	Value Range
REAL	REAL	-3.402823e+38 to 3.402823e+38, with numbers close to zero as small as 1.175495e-38 (single precision floating point number using 4 bytes of storage, rounding errors may occur after the sixth digit)
DOUBLE	DOUBLE	-1.79769313486231e+308 to 1.79769313486231e+308, with numbers close to zero as small as 2.22507385850721e-308 (single precision floating point number using 8 bytes of storage, rounding errors may occur after the fifteenth digit)
NUMERIC	NUMERIC(precision,scale)	Any decimal numbers with precision (size) total digits and with scale digits after the decimal point (no rounding within precision)

Character and Binary Types:

Domain Constant	SQL Type	Size Range
VARCHAR	VARCHAR(size)	1 to 32767 bytes (characters are stored as 1-3 byte UTF-8 characters). When evaluating expressions, the maximum length for a temporary character value is 2048 bytes.
LONGVARCHAR	LONG VARCHAR	Any length (memory permitting).The only operations allowed on LONG VARCHAR columns are to insert, update, or delete them, or to include them in the select-list of a query.
BINARY	BINARY(size)	1 to 32767 bytes. When evaluating expressions, the maximum length for a temporary character value is 2048 bytes.
LONGBINARY	LONG BINARY	Any length (memory permitting).The only operations allowed on LONG BINARY columns are to insert, update, or delete them, or to include them in the select-list of a query.
UUID	UNIQUEIDENTIFIER	Always 16 bytes binary with special interpretation.

Date and Time Types:

Domain Constant	SQL Type	Value
DATE	DATE	Year, month, day.
TIME	TIME	Hour, minute, second, and fraction of a second.
TIMESTAMP	TIMESTAMP	DATE and TIME.
TIMESTAMP_ZONE	TIMESTAMP_ZONE	DATE and TIME with time zone.

BIT columns are not nullable by default. All other types are nullable by default.