Data types
This section describes the data types used in
Derby
.
Built-In type overview
Numeric types
Data type assignments and comparison, sorting, and ordering
BIGINT data type
BLOB data type
CHAR data type
CHAR FOR BIT DATA data type
CLOB data type
DATE data type
DECIMAL data type
DOUBLE data type
DOUBLE PRECISION data type
FLOAT data type
INTEGER data type
LONG VARCHAR data type
LONG VARCHAR FOR BIT DATA data type
NUMERIC data type
REAL data type
SMALLINT data type
TIME data type
TIMESTAMP data type
VARCHAR data type
VARCHAR FOR BIT DATA data type
XML data type
The XML data type is used for Extensible Markup Language (XML) documents.
Parent topic:
SQL language reference
Related concepts
SQL identifiers
Statements
Built-in system functions
Built-in system procedures
Related reference
Capitalization and special characters
SQL clauses
SQL expressions
JOIN operations
SQL queries
Built-in functions
SYSCS_DIAG diagnostic tables and functions