how mapping the TEXT Type to the ODBC Type ?

From: zhaoxin <zhaox(at)necas(dot)nec(dot)com(dot)cn>
To: pgsql-odbc(at)postgresql(dot)org
Subject: how mapping the TEXT Type to the ODBC Type ?
Date: 2006-05-16 14:18:57
Message-ID: 4469DF51.40603@necas.nec.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Browse pgsql-odbc by date

  From Date Subject
Next Message Jonathan Blitz 2006-05-16 16:41:39 SQLCODE when using psqlODBC with libODBC++
Previous Message noreply 2006-05-14 09:34:13 [ psqlodbc-Bugs-1000644 ] codepage issue