Part 4: The Connect XE Drivers : The Greenplum Wire Protocol Driver : Data Types

Data Types
The following table shows how the Greenplum data types are mapped to the standard ODBC data types.

1
Bit maps to SQL_BIT when the length for the bit is 1. If the length is greater than 1, the driver maps the column to SQL_BINARY.

2
Numeric maps to SQL_NUMERIC if the precision of the Numeric is less than or equal to 38. If the precision is greater than 38, the driver maps the column to SQL_VARCHAR.

3
Time mapping changes based on the setting of the Fetch TWFS as Time option.

4
Timestamp with timezone mapping changes based on the setting of the Fetch TSWTZ as Timestamp option.

See Retrieving Data Type Information for more information about data types.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.