Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## Data types syntax in BNF

> ## 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 | CLOB | 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 | TIMESTAMP WITH TIME ZONE

> ##### Bit string data type

> Syntax
>     bit_string_data_type ::=
>     BIT | BINARY [ ( length ) ] | BLOB [ ( length ) ] |
>     VARBINARY [( length ) ] | LONG VARBINARY [( length ) ]

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