Details of the ODBC Interface¶
This section describes information specific to the ODBC interface of Denodo.
How the ODBC Interface Reports the Datetime and Interval Data Types¶
The ODBC interface of Denodo follows the same protocol as PostgreSQL.
The table below lists how the data types of Denodo are mapped to the data types of PostgreSQL.
Type Name in Denodo |
Type Name for PostgreSQL |
Type Code for PostgreSQL |
|---|---|---|
localdate |
date |
1082 |
time |
time |
1083 |
timestamp |
timestamp |
1114 |
date (deprecated) |
timestamptz |
1184 |
timestamptz |
timestamptz |
1184 |
interval_year_month |
interval |
1186 |
interval_day_second |
interval |
1186 |
The types date and timestamptz are reported with the same type (TIMESTAMP WITH TIMEZONE) so a client application cannot distinguish them. This facilitates the upgrade from Denodo 6.0 or previous versions. Client applications do not need to distinguish between these types and should treat both as timestamptz.
The ODBC interface maps VECTOR types to PostgreSQL text fields. Due to the lack of a native vector type in the PostgreSQL protocol, embeddings are serialized as JSON arrays represented as strings.