I changed the driver to handle this a little better.
- text was already SQL_LONGVARCHAR.
- name is now SQL_CHAR (fixed at 32) - it should have been this all along
- varchar and bpchar both return SQL_VARCHAR, BUT varchar now comes first,
since it is most correct anyway, I think that makes sense.
Hope this helps.
The latest stuff is at our web site.
Paul Lisewski wrote:
> When getting a list of DataTypes via SQLGetInfo, there are 4 SQL_VARCHAR
> They are:
> bpchar, varchar, text and name.
> I have a utility to interogate a database and create tables using the
> syntax from SQLGetInfo. I pick the first match from the list (in this
> case bpchar). Could the Types be modified to SQL_LONGVARCHAR for the non
> varchar datatypes or at least resequenced so that varchar comes before
> Various version of PostODBC used to have this problem, then it was
> changed so that bpchar reported SQL_LONGVARCHAR.
pgsql-interfaces by date
|Next:||From: Gerhard Reithofer||Date: 1998-04-17 20:38:36|
|Subject: Re: [INTERFACES] Re: ODBC driver and Dates|
|Previous:||From: Byron Nikolaidis||Date: 1998-04-17 20:27:07|
|Subject: Re: ODBC driver|