Re: Bools as char not providing expected result

HI Abhishek,

Please file this report at postgresql-interfaces/psqlodbc (github.com)
<https://github.com/postgresql-interfaces/psqlodbc>

<https://github.com/postgresql-interfaces/psqlodbc>Thanks,
Dave Cramer
www.postgres.rocks

On Tue, 30 Jul 2024 at 05:56, Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
wrote:

> Hi,
>
> I am working on an ODBC linux CPP application using the psqlodbc driver.
>
> I am passing *"bools_as_char=0;" * when i do a SQLDriverConnect. Below is
> the full connection string
>
>
> "HostName=localhost;PORT=5432;Database=postgres;UID=postgres;PWD=postgres;bools_as_char=0;DRIVER=PostgreSQLNative;"
>
>
> According to my understanding, bool_as_char is set to 1 by default in
> psqlodbc code. I am trying to override that to 0 such that i get the
> boolean treated as a SQL_BIT with precision 1. However, the driver is still
> returning SQL_VARCHAR and precision as 5(PG_WIDTH_OF_BOOLS_AS_CHAR in the
> psqlodbc code).
>
>
> Can you please help here?
>
>
> Regards,
>
> Abhishek
>