SQL Reference Guide

Data Types

The SQL statements CREATE TABLE and ALTER TABLE specify data types for each column in the tables they define. This section describes the data types FairCom DB SQL supports for table columns.

There are several categories of FairCom DB SQL data types:

• Character
• Exact numeric
• Approximate numeric
• Date-time
• Bit String

All of the data types can store null values. A null value indicates that the value is not known and is distinct from all non-null values.

Syntax

data_type ::

char_data_type

| exact_numeric_data_type

| approx_numeric_data_type

| date_time_data_type

| bit_string_data_type

In This Section Character Data Types Exact Numeric Data Types Approximate Numeric Data Types Date-Time Data Types Bit String Data Types