The following table lists the data type codes reported by HELP statements and the data types they represent.
| Data Type Code | Data Type |
|---|---|
| ++ | TD_ANYTYPE |
| A1 | ARRAY (one dimensional) |
| AN | ARRAY (multidimensional) |
| I8 | BIGINT |
| BO | BINARY LARGE OBJECT |
| BF | BYTE |
| BV | BYTE VARYING |
| I1 | BYTEINT |
| CF | CHARACTER (fixed) |
| CV | CHARACTER (varying) |
| CO | CHARACTER LARGE OBJECT |
| D | DECIMAL |
| DA | DATE |
| F | DOUBLE PRECISION DOUBLE PRECISION, FLOAT, and REAL are different names for the same data type. |
| F | FLOAT FLOAT, DOUBLE PRECISION, and REAL are different names for the same data type. |
| I | INTEGER |
| DY | INTERVAL DAY |
| DH | INTERVAL DAY TO HOUR |
| DM | INTERVAL DAY TO MINUTE |
| DS | INTERVAL DAY TO SECOND |
| HR | INTERVAL HOUR |
| HM | INTERVAL HOUR TO MINUTE |
| HS | INTERVAL HOUR TO SECOND |
| MI | INTERVAL MINUTE |
| MS | INTERVAL MINUTE TO SECOND |
| MO | INTERVAL MONTH |
| SC | INTERVAL SECOND |
| YR | INTERVAL YEAR |
| YM | INTERVAL YEAR TO MONTH |
| N | NUMBER |
| D | NUMERIC |
| PD | PERIOD(DATE) |
| PT | PERIOD(TIME(n)) |
| PZ | PERIOD(TIME(n) WITH TIME ZONE) |
| PS | PERIOD(TIMESTAMP(n)) |
| PM | PERIOD(TIMESTAMP(n) WITH TIME ZONE) |
| F | REAL REAL, DOUBLE PRECISION, and FLOAT are different names for the same data type. |
| I2 | SMALLINT |
| AT | TIME |
| TS | TIMESTAMP |
| TZ | TIME WITH TIME ZONE |
| SZ | TIMESTAMP WITH TIME ZONE |
| UT | USER-DEFINED TYPE (all types) |
| XM | XML |