SQLType class

Enumerates the available UltraLite SQL database types used as table column types.

public class SQLType

All members of SQLType class, including all inherited members.

Name	Description
toString method	Generates the string name of the specified SQL column type constant.
BAD_INDEX variable	Column type returned if bad column indentifier is passed to TableSchema.getColumnSQLType().
BINARY variable	Binary data, with a specified length.
BIT variable	1-bit flag.
CHAR variable	Character data, with a specified length.
DATE variable	Date information.
DOUBLE variable	Double precision floating point number (8 bytes).
LONGBINARY variable	Binary data, with variable length.
LONGVARCHAR variable	Character data, with variable length.
MAX_INDEX variable	Reserved.
NUMERIC variable	Exact numerical data, with a specified precision and scale.
REAL variable	Single precision floating point number (4 bytes).
S_BIG variable	Signed 64-bit integer.
S_LONG variable	Signed 32-bit integer.
S_SHORT variable	Signed 16-bit integer.
ST_GEOMETRY variable	Geo spatial data.
TIME variable	Time information.
TIMESTAMP variable	Timestamp information (date, time).
TIMESTAMP_WITH_TIME_ZONE variable	Timestamp zone information.
TINY variable	Unsigned 8-bit integer.
U_BIG variable	Unsigned 64-bit integer.
U_LONG variable	Unsigned 32-bit integer.
U_SHORT variable	Unsigned 16-bit integer.
UUID variable	UUID (Universally Unique Identifer).

Discuss this page in DocCommentXchange.