FrontBase logo

FrontBase Documentation

FrontBase logo

Backtrack:
  Welcome!
    5. SQL 92
Updated: 20-Nov-2000
prevnext
Table of Contents

5.3. FrontBase Datatypes

SQL 92 offers an extensive list of datatypes, all of which are supported by FrontBase. Additionally, FrontBase supports a number of datatypes from SQL3. Although the list of datatypes seem long and maybe even confusing, don't worry. Many of the names denote the same datatype. Such is the work that comes from a comittee.

Section/Article Description
5.3.1. SQL 92 Datatypes SMALLINT, INTEGER, INT
DECIMAL, NUMERIC, FLOAT
REAL, DOUBLE PRECISION
CHARACTER, CHAR
NATIONAL CHARACTER, NATIONAL CHAR, NCHAR
CHARACTER VARYING, CHAR VARYING, VARCHAR
NATIONAL CHARACTER VARYING
NATIONAL CHAR VARYING, NCHAR VARYING
BIT, BIT VARYING
DATE, TIME, INTERVAL
TIME WITH TIME ZONE, TIMESTAMP
TIMESTAMP WITH TIMEZONE
5.3.2. SQL3 Datatypes BLOB, CLOB, BOOLEAN
5.3.3. Proprietary Datatypes BYTE


If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!

©2000 FrontBase, Inc. All rights reserved.