Data TypesINT TypeBOOLEAN 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 TypeINT | INTEGER | MEDIUMINT | INT4 | SIGNED Possible values: -2147483648 to 2147483647 Example:INT BOOLEAN TypeBOOLEAN | BIT | BOOL Possible values: TRUE and FALSE Example:BOOLEAN TINYINT TypeTINYINT Possible values are: -128 to 127 Example:TINYINT SMALLINT TypeSMALLINT | INT2 | YEAR Possible values: -32768 to 32767 Example:SMALLINT BIGINT TypeBIGINT | INT8 Possible values: -9223372036854775808 to 9223372036854775807 Example:BIGINT IDENTITY TypeIDENTITY
Auto-Increment value.
IDENTITY DECIMAL Type{DECIMAL | NUMBER | DEC | NUMERIC} ( precisionInt [, scaleInt] )
Data type with fixed precision and scale.
DECIMAL(20, 2) DOUBLE Type{DOUBLE [PRECISION] | FLOAT | FLOAT4 | FLOAT8}
Floating point number (java.lang.Double).
DOUBLE REAL TypeREAL
Single precision floating point number (java.lang.Float).
REAL TIME TypeTIME The format is hh:mm:ss. Example:TIME DATE TypeDATE 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.
BINARY(1000) OTHER TypeOTHER
This type allows storing serialized Java objects. Internally, a byte array is used.
OTHER VARCHAR Type{VARCHAR | LONGVARCHAR | VARCHAR2 | NVARCHAR | NVARCHAR2 | VARCHAR_CASESENSITIVE} [( precisionInt )]
Unicode String. Use two single quotes ('') to create a quote.
VARCHAR(255) VARCHAR_IGNORECASE TypeVARCHAR_IGNORECASE [( precisionInt )]
Same as VARCHAR, but not case sensitive when comparing. Stored in mixed case.
VARCHAR_IGNORECASE CHAR Type{CHAR | CHARACTER | NCHAR} [( precisionInt )]
This type is supported for compatibility with other databases and older applications.
CHAR(10) BLOB Type{BLOB | TINYBLOB | MEDIUMBLOB | LONGBLOB | IMAGE | OID} [( precisionInt )]
Like BINARY, but intended for very large values.
BLOB CLOB Type{CLOB | TINYTEXT | TEXT | MEDIUMTEXT | LONGTEXT | NTEXT | NCLOB} [( precisionInt )]
Like VARCHAR, but intended for very large values.
CLOB UUID TypeUUID
Universally unique identifier. This is a 128 bit value.
UUID ARRAY TypeARRAY
An array of values.
ARRAY |