Re: Unable to Query the datatype varchar of PostgreSQL Server

Hello,

> We are trying to fetch records from Postgre Tables.
>
> We are successfully able to build connectivity. We are Using Postgre ODBC
> Driver (Unicode).
>
> But when I query the tables of Postgre it is unable to map the datatype
> varchar of source Table.

When you use Unicode all VARCHAR is treated as not ansi but as
wide varchar (WVARCHAR).

Please try Postgres ODBC Driver (ANSI).

> CAUSE DETERMINATION
> ====================
> VARCHAR datatype from PostgreSQL is translated by your ODBC driver in an
> unsupported datatype for HSODBC.

What is HSODBC?

> To get confirmation, please have a look in the documentation:
>
> Oracle® Database Heterogeneous Connectivity Administrator's Guide
> 10g Release 2 (10.2)
> Part Number B14232-01
> B Data Type Mapping for Generic Connectivity
> B.1 Mapping ANSI Data Types to Oracle Data Types Through an ODBC Interface

Here is ANSI so why you don't use psqlodbc ANSI?

> Can you please suggest why varchar datatype is not correctly identified
> and what is the path to get solution?

It is correctly identified as I wrote above.

Regards,

Luf