Bools as char not providing expected result

From: Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Bools as char not providing expected result
Date: 2024-07-30 09:40:14
Message-ID: CAAyULECNUXQZoQ6p9JMQ17sS1+DGkp-1LBUqUnQTqDeuCy442g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2024-07-30 10:42:21 Re: Bools as char not providing expected result
Previous Message Rodrigo Garzón 2024-07-18 14:00:58 Re: PLASE HELP- Error ANSI 13 in ARM Windows 11