Documentation

SQL Reference Guide

Previous Topic

Next Topic

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

TOCIndex