| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-odbc(at)postgreSQL(dot)org |
| Subject: | Fwd: [BUGS] BUG #12897: SQLDescribeColumn() and bit columns |
| Date: | 2015-03-25 17:40:38 |
| Message-ID: | 7790.1427305238@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
forwarded from core bugs list
------- Forwarded Message
Date: Wed, 25 Mar 2015 14:05:22 +0000
From: smarvin(at)pobox(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: [BUGS] BUG #12897: SQLDescribeColumn() and bit columns
The following bug has been logged on the website:
Bug reference: 12897
Logged by: Steve Marvin
Email address: smarvin(at)pobox(dot)com
PostgreSQL version: 9.4.1
Operating system: Windows 8.1
Description:
when using statement 'select btest from public.tblname limit 1',
SQLDescribeColumn(1,...) returns nSQLType of 12 (SQL_VARCHAR) and length of
255 on columns of type 'bit' instead of -7(SQL_BIT) and length of 1.
select * from information_schema.columns using tablename,columnname,catalog
shows
the data_type is 'bit' and all other column information is correct.
ODBC Driver is PostgreSQL ANSI 9.03.04.00 10/26/2014.
Tested both x86 and x64 drivers.
------- End of Forwarded Message
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert S. Bachman | 2015-03-25 21:20:28 | Installation problems |
| Previous Message | yuriana saldivar diaz | 2015-03-24 20:03:21 | Controlador psqlodb |