| From: | "Lawrence, Mike(SDST)" <Mike(dot)Lawrence(at)dell(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | psqlODBC Unicode(x64) driver treats a boolean field as text |
| Date: | 2021-07-22 14:43:52 |
| Message-ID: | SJ0PR19MB45259F3A22D90C7C58FB603E95E49@SJ0PR19MB4525.namprd19.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Bug reference: 17115
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.
Mike Lawrence
Consultant Product Manager, Product Management
Dell Technologies | DT Services Technologies
Mike(dot)Lawrence(at)Dell(dot)com<mailto:Mike(dot)Lawrence(at)Dell(dot)com>
Home Office: Moorpark, CA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Russo (mrusso) | 2021-07-23 16:06:31 | “FATAL: role “username” does not exist”. Thanks. |
| Previous Message | Dmitriy Muzalkov | 2021-07-22 13:07:41 | postgresql odbc driver compilation solaris 11.4 |