The following section describes how the driver handles partially and unsupported data types.

Partially supported data types

The following table contains the PostgreSQL data types that are partially supported by the driver. These data types map the SQL_VARCHAR ODBC type with a scale of 0.

Table 1. Partially Supported Data Types
PostgreSQL Data Type Precision
Box 255
Cidr 50
Inet 50
Int4 255
Interval 255
Lseg 255
Macaddr 17
Money 255
Point 255
Point 255
Polygon 255
Timetz 21

Unsupported data types

The following data types are not supported by the driver. When encountered by the driver, unsupported types map to the SQL_VARCHAR type with a precision of 10485760 and scale 0.
  • UUID
  • Record

Interval Types

The following Interval Types are not supported and map to SQL_VARCHAR with an incorrect precision:
  • INTERVAL DAY
  • INTERVAL DAY TO HOUR
  • INTERVAL DAY TO MINUTE
  • INTERVAL DAY TO SECOND

  • INTERVAL HOUR

  • INTERVAL HOUR TO SECOND

  • INTERVAL MINUTE

  • INTERVAL MINUTE TO SECOND
  • INTERVAL MONTH
  • INTERVAL SECOND
  • INTERVAL YEAR
  • INTERVAL YEAR TO MONTH

Information Schema Types

The columns of the information schema views use special data types that are defined in the information schema. These data types are not used while creating the table and are not supported by the driver. By default, the driver maps the following information schema types to SQL_VARCHAR:

  • cardinal_number
  • character_data
  • sql_identifier
  • time_stamp
  • yes_or_no