Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group