[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: BUG #17115: psqlODBC Unicode(x64) driver treats a boolean field as text
From:       John Naylor <john.naylor () enterprisedb ! com>
Date:       2021-07-22 12:43:10
Message-ID: CAFBsxsF3NQA4gwY8gsyvYtQmpFObCN8YY2Rvo+44zCAQpEOxmg () mail ! gmail ! com
[Download RAW message or body]

On Thu, Jul 22, 2021 at 7:23 AM PG Bug reporting form <
noreply@postgresql.org> wrote:
> When I use the psqlODBC Unicode(x64) driver for importing data into Power
> BI, all three of my Boolean fields are incorrectly identified as type
Text.
> I am using Unicode because of differing code pages and the inability to
> translate between them with the ANSI(x64) driver. This does not happen
when
> I have a direct connection in Power BI with a copy of the database, as it
> correctly identifies the field as Boolean.

Hi,

You may report psqlODBC issues here:

pgsql-odbc@postgresql.org

https://odbc.postgresql.org/faq.html#1.6

--
John Naylor
EDB: http://www.enterprisedb.com

[Attachment #3 (text/html)]

<div dir="ltr">On Thu, Jul 22, 2021 at 7:23 AM PG Bug reporting form &lt;<a \
href="mailto:noreply@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br>&gt; \
When I use the psqlODBC Unicode(x64) driver for importing data into Power<br>&gt; BI, \
all three of my Boolean fields are incorrectly identified as type Text.<br>&gt; I am \
using Unicode because of differing code pages and the inability to<br>&gt; translate \
between them with the ANSI(x64) driver. This does not happen when<br>&gt; I have a \
direct connection in Power BI with a copy of the database, as it<br>&gt; correctly \
identifies the field as Boolean.<br><br>Hi,<div><br></div><div>You may report \
psqlODBC issues here:</div><div><br><a \
href="mailto:pgsql-odbc@postgresql.org">pgsql-odbc@postgresql.org</a><br><br><a \
href="https://odbc.postgresql.org/faq.html#1.6">https://odbc.postgresql.org/faq.html#1.6</a><br></div><br>--<br>John \
Naylor<br>EDB: <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><div><br></div></div>




[prev in list] [next in list] [prev in thread] [next in thread]