Types Table: OA_TYPES
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The OA_ TYPES contains information about data types supported by the underlying data source. This information is used to support the SQLGetTypeInfo ODBC call.
If the schema request is mapped to a function call, the cursor opened when information about data types is returned must match the column sequence and types as detailed below. The column name is not important.
Definition of Types Table OA_TYPES
| Column Name | Type | Len | Description |
| TYPE_NAME | WVARCHARnot NULL | 128 | Data source-dependent type name |
| DATA_TYPE | SMALLINT not NULL | ODBC SQL data type | |
| OA_PRECISION | INTEGER | The maximum precision of the data type on the data source. NULL is returned for data types where precision is not applicable. | |
| LITERAL_PREFIX | VARCHAR | 128 | Character or characters used to prefix a literal. |
| LITERAL_SUFFIX | VARCHAR | 128 | Character or characters used to suffix a literal. |
| CREATE_PARAMS | VARCHAR | 128 | Parameters for data type definition. |
| OA_NULLABLE | SMALLINT not NULL | Whether the data type can be null: XO_NO_NULLS (0) – No nulls allowed XO_NULLABLE (1) – Can be null XO_NULLABLE_UNKNOWN (2) – Nullable unknown |
|
| CASE_SENSITIVE | SMALLINT not NULL | Whether the data type is case sensitive in collation and comparison. TRUE if the data type is a character data type and it is case sensitive. FALSE if the data type is not a character data type or is not case sensitive. |
|
| OA_SEARCHABLE | SMALLINT not NULL | How the data type is used in a WHERE clause. | |
| UNSIGNED_ATTRIB | SMALLINT | Whether the data type is unsigned. OpenAccess SDK does not support unsigned data types. | |
| OA_MONEY | SMALLINT not NULL | Whether the data type is a money data type. | |
| AUTO_INCREMENT | SMALLINT | Whether the data type is autoincrementing. | |
| LOCAL_TYPE_NAME | WVARCHAR | 128 | Localized version of the database dependent data type name. |
| MINIMUM_SCALE | SMALLINT | Minimum scale of the data type. | |
| MAXIMUM_SCALE | SMALLINT | Maximum scale of the data type. | |
| OA_SQL_DATA_TYPE | smallint not NULL | 16 | The value of the SQL data type as it appears in the SQL_DESC_TYPE field of the descriptor. This column is the same as the DATA_TYPE column except for the datetime data types DATE, TIME, TIMESTAMP. For datetime data types, the OA_SQL_DATA_TYPE field in the result set will be SQL_DATETIME (9), and the OA_SQL_DATETIME_SUB field will return the subcode for the specific datetime data type (SQL_CODE_DATE, SQL_CODE_TIME or SQL_CODE_TIMESTAMP). |
| OA_SQL_DATETIME_SUB | smallint | 17 | The subtype code for datetime data types. For other data types, this column returns a NULL. SQL_CODE_DATE=1 SQL_CODE_TIME=2 SQL_CODE_TIMESTAMP=3 |
| OA_NUM_PREC_ RADIX | integer | 18 | If the data type is an approximate numeric type, this column contains the value 2 to indicate that COLUMN_SIZE specifies a number of bits. For exact numeric types, this column contains the value 10 to indicate that COLUMN_SIZE specifies a number of decimal digits. Otherwise, this column is NULL. |
| OA_INTERVAL_ PRECISION | smallint | 19 | Return NULL. The interval data type is not supported. |
Sample data to be used for this table is provided in an oa_types.csv file that can be downloaded from the same site from which you downloaded OpenAccess SDK.