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 ’31-DEC-08’ or ’31-DEC-2008’. 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.
|