From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
---|---|
To: | Paul Lisewski <paull(at)techone(dot)com(dot)au>, pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: ODBC driver (SQLGetTypeInfo) |
Date: | 1998-04-17 20:33:22 |
Message-ID: | 3537BC92.9E2BB7D7@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Paul,
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.
Byron
Paul Lisewski wrote:
> When getting a list of DataTypes via SQLGetInfo, there are 4 SQL_VARCHAR
> types.
> 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
> bpchar
>
> Various version of PostODBC used to have this problem, then it was
> changed so that bpchar reported SQL_LONGVARCHAR.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Reithofer | 1998-04-17 20:38:36 | Re: [INTERFACES] Re: ODBC driver and Dates |
Previous Message | Byron Nikolaidis | 1998-04-17 20:27:07 | Re: ODBC driver |