Progress
Database Administration
Guide and Reference


Data Types and Values

Table 3–9 lists the Progress SQL-92 data types and value limits.

Table 3–9: SQL-92 Data Type Limits
SQL-92 Data Type
Limit
BIGINT
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
BINARY
2000 bytes
BIT
0 or 1
CHAR
2000 characters
DATE
Year: 1 to 9999; Month: 1 through 12; Date: 1 through the last day of the month
DECIMAL
Defined in terms of precision and scale. Precision=number of digits; scale=number of digits to the right of the decimal point. Note that scale cannot be greater than precision. Precision is limited to 50. Scale is limited to 10.
DOUBLE PRECISION
2.2250738585072014E-308 through 1.7976931348623157E+308
FLOAT
2.2250738585072014E-308 through 1.7976931348623157E+308
INTEGER
-2,147,483,648 to 2,147,483,647
NUMERIC
Defined in terms of precision and scale. Precision=number of digits; scale=number of digits to the right of the decimal point. Note that scale cannot be greater than precision. Precision is limited to 50. Scale is limited to 10.
REAL
1.175494351E-38F to 3.402823466E+38F
SMALLINT
-32,768 to 32,767
TIME
00:00:00 to 23:59:59
TIMESTAMP
Combination of Date and Time limits
TINYINT
-128 to 127
VARBINARY
31,995 bytes
VARCHAR
31,995

The following table lists the 4GL data types and value limits:

4GL Data Type
Limit
CHARACTER
Constrained by record size. (If a field has more than 3,000 bytes, you must write your own dump/reload procedure because the Progress dump/reload procedure cannot handle fields larger than 3,000 bytes.)
DATE
1/1/32768 B.C. to 12/31/32767 A.D.
DECIMAL
50 digits total; 1 to 10 decimal places
INTEGER
–2,147,483,648 to 2,147,483,647.
LOGICAL
TRUE/FALSE, YES/NO.

NOTE: Data columns created using the Progress SQL-92 environment and having a data type that is not supported in the Progress 4GL environment are not accessible by Progress 4GL applications. Data columns created using the Progress 4GL environment can be accessed by Progress SQL-92 applications and utilities.

The following table describes data types supported by Progress 4GL and their corresponding SQL-92 data types:

Progress 4GL Data Type
Progress SQL-92 Data Type
CHARACTER
VARCHAR
DATE
DATE
DECIMAL
DECIMAL or NUMERIC
INTEGER
INTEGER
LOGICAL
BIT
RAW
VARBINARY
RECID
INTEGER


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