Type codes v17
Type codes for external data types
The following table contains the type codes for external data types. An external data type is used to indicate the type of a C host variable. When an application binds a value to a parameter or binds a buffer to a SELECT
-list item, set the type code in the corresponding SQLDA descriptor (descriptor->T[column])
to one of the following values:
Type code | Host variable type (C data type) |
---|---|
1, 2, 8, 11, 12, 15, 23, 24, 91, 94, 95, 96, 97 | char[] |
3 | int |
4, 7, 21 | float |
5, 6 | null-terminated string (char[length+1]) |
9 | varchar |
22 | double |
68 | unsigned int |
Type codes for internal data types
The following table contains the type codes for internal data types. An internal type code is used to indicate the type of a value as it resides in the database. The DESCRIBE SELECT LIST
statement populates the data type array (descriptor->T[column])
using the following values.
Internal type code | Server type |
---|---|
1 | VARCHAR2 |
2 | NUMBER |
8 | LONG |
11 | ROWID |
12 | DATE |
23 | RAW |
24 | LONG RAW |
96 | CHAR |
100 | BINARY FLOAT |
101 | BINARY DOUBLE |
104 | UROWID |
187 | TIMESTAMP |
188 | TIMESTAMP W/TIMEZONE |
189 | INTERVAL YEAR TO MONTH |
190 | INTERVAL DAY TO SECOND |
232 | TIMESTAMP LOCAL_TZ |