Postgres Pro
Downloads
Home   >   mailing lists

how mapping the TEXT Type to the ODBC Type ? - Mailing list pgsql-odbc

From zhaoxin
Subject how mapping the TEXT Type to the ODBC Type ?
Date
Msg-id 4469DF51.40603@necas.nec.com.cn
Whole thread Raw
List pgsql-odbc
Tree view 
Hi ,

I have a question about psqlodbc's text Data Type.
what is the mapping of the text Type to ODBC Data Type by SQLColumns
function .
When I test , I can get SQL_DATA_TYPE = -10 if column is text type.
but I don't know how mapping this type to ODBC Data Type.
SQL_LONGVARCHAR or SQL_VARCHAR ot others ?
can you help me ?

by the way .
   bytea ---> SQL_VARBINARY
is it right ?

Regards, Zhao.

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000644 ] codepage issue
Next
From: "Jonathan Blitz"
Date:
Subject: SQLCODE when using psqlODBC with libODBC++