Postgres Pro
Downloads
Home   >   mailing lists

Re: Bools as char not providing expected result - Mailing list pgsql-odbc

From Abhishek Kumar
Subject Re: Bools as char not providing expected result
Date
Msg-id CAAyULEDbZ92AsVZBokvtpySbK4RomdGyvb5W1ROyArn55iRJfQ@mail.gmail.com
Whole thread Raw
In response to Re: Bools as char not providing expected result  (Dave Cramer <davecramer@postgres.rocks>)
List pgsql-odbc
Tree view
Hi Dave,

I could get the solution to this. The flag is "BoolsAsChar" and not "bools_as_char". With BoolsAsChar, it works fine.

Regards,
Abhishek Kumar

On Tue, Jul 30, 2024 at 4:12 PM Dave Cramer <davecramer@postgres.rocks> wrote:
HI Abhishek,


Thanks,
Dave Cramer
www.postgres.rocks


On Tue, 30 Jul 2024 at 05:56, Abhishek Kumar <abhishek.aak0@gmail.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

pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Bools as char not providing expected result
Next
From: Jon Raiford
Date:
Subject: Windows for ARM support?