Progress
SQL-92
Guide and Reference


DATA TYPE

SYNTAX

data_type ::=
char_data_type
  | exact_numeric_data_type | approx_numeric_data_type
  | date_time_data_type | bit_string_data_type 

CHARACTER DATA TYPE

SYNTAX
char_data_type ::=
{ CHARACTER | CHAR } [ ( length ) ] 
  | { CHARACTER VARYING | CHAR VARYING | VARCHAR }
  [ (length) ]  

EXACT NUMERIC DATA TYPE

SYNTAX
exact_numeric_data_type ::=
TINYINT
  | SMALLINT
  | INTEGER
  | NUMERIC | NUMBER [ ( precision [ , scale ] ) ] 
  | DECIMAL [ ( precision , scale ) ]  

APPROXIMATE NUMERIC DATA TYPE

SYNTAX
approx_numeric_data_type ::=
  { REAL | DOUBLE PRECISION | FLOAT [ ( precision ) ] } 

DATE-TIME DATA TYPE

SYNTAX
date_time_data_type ::
DATE | TIME | TIMESTAMP 

BIT STRING DATA TYPE

SYNTAX
bit_string_data_type ::=
BIT | BINARY [ ( length ) ] | VARBINARY [( length ) ]
    | LONG VARBINARY [( length ) ] 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095