Oracle

Progress

CHAR(N) alphanumeric data up to N characters. It always store N characters no matter what. It will append blanks to the end if you assign less data. Obsolete.

None

VARCHAR2(N) alphanumeric data up to N characters. Unlike CHAR(N) will not append blanks and store only as much as required

CHARACTER. Unlike Oracle format x(N) is only for display purposes. It could store up to max 32000 regardless of format.

DATE
Default format ’31DEC08’ or ’31DEC2008’. Note single quotes.

DATE
Default format 12/31/08 or 12/31/2008

NUMBER(n,m). The value for n is the size and m is precision. So m is the portion of n that is defined to the right of decimal point.
NUMBER(n,m) will accept up to n significant digits of which m are to the right of decimal point.

None

NUMERIC, DEC, DECIMAL

DECIMAL decimals m. The value for m is number of decimal points. Default is 2.

BOOLEAN

LOGICAL

INT

INTEGER

ROWID, BLOB, CLOB and RAW are the same.
Progress does not have BFILE, BINARY_INTEGER, SMALLINT, POSITIVE, NATURAL, MLSLABEL, TABLE data types.
