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           
 15      93    timestamp      
 16    2005    clob           
 17       2    numeric        
 18       3    number         
 19    2004    bytes          
 20    2004    binary         
 21    2004    binary varying 
 22      16    boolean