Re: Report BUG: The column size for BIT VARYING(5) type is incorrect - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: Report BUG: The column size for BIT VARYING(5) type is incorrect
Date
Msg-id 5b781d8a-1384-32be-1fbf-4e9c184e0467@ladisch.de
Whole thread Raw
In response to Report BUG: The column size for BIT VARYING(5) type is incorrect  ("James (Ke) Wang" <james.wang@sas.com>)
Responses Re: Report BUG: The column size for BIT VARYING(5) type is incorrect
List pgsql-odbc
James (Ke) Wang wrote:
> create table j_varbit2 (vbt1 bit varying (5))
>
> *ColumnName = "vbt1", *NameLengthPtr = 4, *DataTypePtr = SQL_WVARCHAR=-9, *ColumnSizePtr = 1, *DecimalDigits = 0,
*NullablePtr= SQL_NULLABLE=1
 
>
> Why is the *ColumnSizePtr = 1 instead of *ColumnSizePtr = 5 since the column is created with bit varying (5) in the
testcase?
 

The ODBC specification does not define the data type BIT VARYING, so the
ODBC driver tries to represent it as a blob or text.

And five bits fit into one byte.


Regards,
Clemens



pgsql-odbc by date:

Previous
From: "James (Ke) Wang"
Date:
Subject: Report BUG: The column size for BIT VARYING(5) type is incorrect
Next
From: Frank Slicer
Date:
Subject: Source or binaries for pgsql-odbc for Linux (Amazon Linux 2)