Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id RAA07192 for ; Fri, 17 Apr 1998 17:12:09 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.8.5/8.8.5) with UUCP id QAA03414 for pgsql-interfaces@postgreSQL.org; Fri, 17 Apr 1998 16:59:49 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA19474; Fri, 17 Apr 1998 16:41:13 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA58744; Fri, 17 Apr 1998 16:29:50 -0400 Message-Id: <3537BC92.9E2BB7D7@insightdist.com> Date: Fri, 17 Apr 1998 16:33:22 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Paul Lisewski , pgsql-interfaces Subject: Re: ODBC driver (SQLGetTypeInfo) References: <5ABEF3A77B39D111970F0020AFA04D29AE1F@mailbox.techone.com.au> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. >