From: Byron Nikolaidis <byronn@insightdist.com>
To: Paul Lisewski <paull@techone.com.au>
To: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: ODBC driver (SQLGetTypeInfo)
Date: Fri, 17 Apr 1998 16:33:22 -0400
Message-ID: <3537BC92.9E2BB7D7@insightdist.com> (raw)
References: <5ABEF3A77B39D111970F0020AFA04D29AE1F@mailbox.techone.com.au>
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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, paull@techone.com.au
Subject: Re: ODBC driver (SQLGetTypeInfo)
In-Reply-To: <3537BC92.9E2BB7D7@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox