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
  
• BOOLEAN 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
  
• User-defined types
  
• VARCHAR data type
  
• VARCHAR FOR BIT DATA data type
  
• XML data type
  The XML data type is used for Extensible Markup Language (XML) documents.