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
  
• BLOB
  
• CHAR
  
• CHAR FOR BIT DATA
  
• CLOB
  
• DATE
  
• DECIMAL
  
• DOUBLE
  
• DOUBLE PRECISION
  
• FLOAT
  
• INTEGER
  
• LONG VARCHAR
  
• LONG VARCHAR FOR BIT DATA
  
• NUMERIC
  
• REAL
  
• SMALLINT
  
• TIME
  
• TIMESTAMP
  
• VARCHAR
  
• VARCHAR FOR BIT DATA
  
• XML data type
  The XML data type is used for Extensible Markup Language (XML) documents.