Data Types

• Numeric Types
  • INT/INTEGER
  • SHORT/SMALLINT
  • BIGINT
  • NUMERIC/DECIMAL
  • FLOAT/REAL
  • DOUBLE/DOUBLE PRECISION
• Date/Time Types
  • DATE
  • TIME
  • TIMESTAMP
  • DATETIME
  • CASTing a String to Date/Time Type
• Date/Time Types with Timezone
  • Timezone Configuration
  • Timezone Function
  • Functions with a Timezone Type
  • Conversion Functions for Timezone Types
  • IANA Timezone
• Bit Strings
  • BIT(n)
  • BIT VARYING(n)
• Character Strings
  • CHAR(n)
  • VARCHAR(n)/CHAR VARYING(n)
  • STRING
  • Escape Special Characters
• ENUM Data Type
  • ENUM Type Comparisons
  • ENUM Type Ordering
  • Notes
• BLOB/CLOB Data Types
  • BLOB
  • CLOB
  • To Create and alter LOB
  • To store and update LOB
  • To access LOB
  • Functions and Operators for LOB
  • To create and manage LOB storage
  • Transaction and Recovery
• Collection Types
  • SET
  • MULTISET
  • LIST/SEQUENCE
• Implicit Type Conversion
  • Conversion Rules