DATATYPES System Table Description

Description

Contains the types of data the database supports. This is a static table that does not change based on actions in the database. It would rarely change from one NuoDB release to the next.

Fields

Field Type Description

ID

integer

NuoDB assigned Identifier

JDBCTYPE

integer

Corresponding JDBC java.sql.Types constant

NAME

string

String used to describe the type in error messages, etc.

Indexes

Primary Index: DATATYPES..PRIMARY_KEY on field: ID

Example

SELECT * FROM system.datatypes;
 ID  JDBCTYPE             NAME
 --- --------- ---------------------------

  0       0    <null>
  1      12    string
  2       1    char
  3      12    varchar
  4       5    smallint
  5       4    integer
  6      -5    bigint
  7       6    float
  8       8    double
  9      91    date
 10      93    timestamp
 11      92    time
 12    2005    clob
 13    2004    blob
 14    2004    blob
 16    2005    clob
 17       2    numeric
 18       3    number
 19    2004    bytes
 20    2004    binary
 21    2004    binary varying
 22      16    boolean
 23    2003    array
 24       2    numeric
 25      93    timestamp without time zone
 26      93    timestamp with time zone
 27      92    time without time zone