Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6a2l-0000fO-Cz for pgsql-odbc@arkaria.postgresql.org; Thu, 22 Jul 2021 14:51:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6a2E-0005IS-TQ for pgsql-odbc@arkaria.postgresql.org; Thu, 22 Jul 2021 14:50:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6a24-00016w-Fp for pgsql-odbc@lists.postgresql.org; Thu, 22 Jul 2021 14:50:40 +0000 Received: from mx0a-00154904.pphosted.com ([148.163.133.20]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6Zvd-0000bK-4L for pgsql-odbc@postgresql.org; Thu, 22 Jul 2021 14:44:05 +0000 Received: from pps.filterd (m0170390.ppops.net [127.0.0.1]) by mx0a-00154904.pphosted.com (8.16.0.43/8.16.0.43) with SMTP id 16MEakcW002073 for ; Thu, 22 Jul 2021 10:43:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dell.com; h=from : to : subject : date : message-id : content-type : mime-version; s=smtpout1; bh=JK//1pC0mkEAY1Sis3JpS/OtWSB1eiq0CGwcMem9bHo=; b=YA1Pah1IUbte9aIHLCJEw6eDlB8PbacZya8O4F5/mProkGSHaXjH96KS/s8fUgwPz4Ib lIJCLVfKYfuwAeaDFcOvcm/GxLcptrfmuQ1kgBryC2AqDNYlrfq6hpIauVoNEjrvXeh5 l2tdKYk4fjrZMPh1qW3Q2GkfSOJ1ENN2wY/vErm5gaOseUzmfpu/HyRgQiWbc/rOgOxt gxpOnEPW8KZqNNp+UH53Hv/2gpr99WVQKnZP2MPLQsxs/vhuUl8nF70lgYsHupyOk3mh OVRTP5cS4x9VGAFm72askXckqjJBWP98i3kcCoMGdVwyNSL/1QZF36iF8tKyw+NfmXth rw== Received: from mx0b-00154901.pphosted.com (mx0b-00154901.pphosted.com [67.231.157.37]) by mx0a-00154904.pphosted.com with ESMTP id 39y9bb0faf-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Thu, 22 Jul 2021 10:43:56 -0400 Received: from pps.filterd (m0144103.ppops.net [127.0.0.1]) by mx0b-00154901.pphosted.com (8.16.0.43/8.16.0.43) with SMTP id 16MEcIxe149912 for ; Thu, 22 Jul 2021 10:43:55 -0400 Received: from nam12-bn8-obe.outbound.protection.outlook.com (mail-bn8nam12lp2171.outbound.protection.outlook.com [104.47.55.171]) by mx0b-00154901.pphosted.com with ESMTP id 39y78dbnbe-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=OK) for ; Thu, 22 Jul 2021 10:43:55 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=iaa2jxPw4vAlZVorR4TyLv21aUlvuUyxa5XUtjaPIw199MirIdQH0i6ntVMZp8On4Z+8G9uG6Pf1tqwITzWnKSPMj2iFXKk/JaEfVV9Nalrezc6uAaZaWwWzRUzV4MH9xVuVWHTNuhJbcohBYBbcwFivM7ZhYtQpz1pKhjKRJT+baPODNnYSO8YpYtZ/Nb7BXllyB6AA+8bdMOhgpIvY39m9YH5tNs2R1YsVP8Ixts6TqEbEUBxMDOcBIh3PRMXGya1foY2PnMpPSEyiuQ/Cc2Jy3x9PCqNHCSYXFr/wsOmU9LP4hS/I2GvqGFeFT8YI/+oQf0oI9qWOIzWpFsOhBw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=JK//1pC0mkEAY1Sis3JpS/OtWSB1eiq0CGwcMem9bHo=; b=BWaPhsqom772w4EOGgE6X3wjZcdsazy7o69QkBY3B85AAkrY3UU4Nx98/c3DiYrbC5A8yl96E3RiDEs/OIqZUgpORej6DOBmh4S+9iirn3bAIjNuEB6b1SxeuvyRJ8gehkOcKbsE/M6Ez4KSY/ePhKl1mHydDL819GiSMziZdJaZLNto0YFZdHZ3gsqzrT8kQoryQRDTXcdEzs0+jFq+u+dtXBfRJq6Fw7gfMFvVJYGp1XD9mQpL80SVwV/4VIIqD09E2hu1QqRTcpKTOkDM3FUqPwcLvEGmDxbdDKt0qLQWSmnLT1MdzhLld156/CjUD5y8B5DYAGcPuHqwl0YfBQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=dell.com; dmarc=pass action=none header.from=dell.com; dkim=pass header.d=dell.com; arc=none Received: from SJ0PR19MB4525.namprd19.prod.outlook.com (2603:10b6:a03:283::13) by SJ0PR19MB4640.namprd19.prod.outlook.com (2603:10b6:a03:286::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4352.26; Thu, 22 Jul 2021 14:43:52 +0000 Received: from SJ0PR19MB4525.namprd19.prod.outlook.com ([fe80::c146:eda1:3e10:a457]) by SJ0PR19MB4525.namprd19.prod.outlook.com ([fe80::c146:eda1:3e10:a457%6]) with mapi id 15.20.4352.025; Thu, 22 Jul 2021 14:43:52 +0000 From: "Lawrence, Mike(SDST)" To: "pgsql-odbc@postgresql.org" Subject: psqlODBC Unicode(x64) driver treats a boolean field as text Thread-Topic: psqlODBC Unicode(x64) driver treats a boolean field as text Thread-Index: Add/B/GrqP/kLqqERE2BxGn+yGZCAA== Date: Thu, 22 Jul 2021 14:43:52 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_Enabled=True; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_SiteId=945c199a-83a2-4e80-9f8c-5a91be5752dd; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_Owner=Mike.Lawrence@dell.com; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_SetDate=2021-07-22T14:43:51.2715672Z; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_Name=External Public; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_Application=Microsoft Azure Information Protection; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_ActionId=c03bc46b-ae01-4392-ac17-f00bc2eef337; MSIP_Label_17cb76b2-10b8-4fe1-93d4-2202842406cd_Extended_MSFT_Method=Manual authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=dell.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 97e6fd2e-4c11-4eb4-a60a-08d94d1f2001 x-ms-traffictypediagnostic: SJ0PR19MB4640: x-microsoft-antispam-prvs: x-exotenant: 2khUwGVqB6N9v58KS13ncyUmMJd8q4 x-ms-oob-tlc-oobclassifiers: OLM:6430; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 1DXLs6JZNP5/kbenIIhZnW4YqtCxtxcfVkc0jFZkV9psJG4l0QM3OtVRabiTSrnhBvrGt30Ms7I7Nc4vmWCQYM7JkjH24Pm5wc6xUxlx94AGFDdDSrcz8Z6Rgq5RGtS1pT8/ZteSLc1CyI1o+r3SyxNkPV3hQhFxQwiivg2CpJ9vl/WeUOvRfTozEK/PcSbw1wWBQPnJtWjgdMd/NskjNbz8mk8ERJtR3AkpNfkCRNeKVcTR6B8ieKnYnBSE+CzJvJKQDJOm01Rg24QFRX1y2U2LKt0/mEAy7PHsQmf3k2hQq5TZllqiQ9JajAJTzaK7YclEx0SK8oOG1NAqiHn/0AwM4OntBsblNiQqxJ3ME9EFsPbmeF9Lqr8wwNAgjmptYSxYiVtrmw77lObr5rFtxzdfbWmGc9e3/UM9UZOVvCa2LUmdmLzEubxS8X3rqYPEstgoPtvH41wh5ur3cMpiEuevniltYafueb8ITB0Pi0MIqW6yCqeQYGBlFReSr5bp6YzQWVgmYt/VijhjpYOzGP4xH3iS8wi7cDOKMnoBcKA9UNBs75NMb0JVPyfZCEagSq57NYYTMi8+3r6ztwDv2NghJKkiLUgUYLBktUqWYn8yeIR7/TOVMYcv0QhHUMErkZ9dsfHudrOZ1pltnkRQ2pxURleWG/s3oytdlbu6zGjEP1MsuKuwm7dWS7i7VwA1jQyJb03jJ6yOd+bIom59Kg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SJ0PR19MB4525.namprd19.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(346002)(376002)(396003)(39860400002)(136003)(52536014)(76116006)(122000001)(71200400001)(4744005)(9686003)(6506007)(66946007)(66556008)(66476007)(64756008)(38100700002)(66446008)(316002)(786003)(2906002)(6916009)(86362001)(7696005)(186003)(478600001)(33656002)(55016002)(8676002)(5660300002)(26005)(8936002)(38070700004);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?OdtyZYvl0oqJ7vAqgbYI99w2ljXZeqxzNVVKkT225EfB0xcml2yjdOBBat6v?= =?us-ascii?Q?uIPr/5xXgNTL4zYsggfotNUjMNZv5SiauVEjljfYYZt06uWknqJyzdBY0WTW?= =?us-ascii?Q?Ay/yOEOeL7t/wz22vnihisG6ZlYSuf3RW4uaj0cFaL2ezn5mov3J7/LTEIvq?= =?us-ascii?Q?NdAePhU8sNsw4NEvNqJnd0RYu7xursxbT+sFpDHRl5NYua5gIes7M01AChJS?= =?us-ascii?Q?GSh5rADhcOqJzOnSNV0OjHsjDBFa9RRsaZ7NODYUbbe4xEr1AL0LSXLs9PY4?= =?us-ascii?Q?G+Htn2wLcOlqHyQ8umT539pEgRF2Ydwg7v38TxR7xYXbqQAs36zYODPr0J39?= =?us-ascii?Q?toZcl2/6YNOLlHW+FdmavFpqKImY0ZaM3g94Sq9urwCWxV++kJPKnyB3uHve?= =?us-ascii?Q?/zp9vy5Klvxdye5SBGl8JoB7izyjmwXdUaCQ+aHCqsm9cD72mq0uA0cNGzxU?= =?us-ascii?Q?MwRK87ffeaweZLSVDEfNE2euwCKzK4oW0xqpxwFlw6+HnrkS3vLhA01ffbx0?= =?us-ascii?Q?wW3oPW2lTgSWxPh1BXhtOhOsbNRhBTmbDrZtEXj+2jikfOiX4+ACKj4O7uaz?= =?us-ascii?Q?ltVKuvVz+ParlNXmHCWuyDpAKmDF4QEmggGKk/zEep/UrJ568p7Wv+3U0Zfv?= =?us-ascii?Q?O4hLjJQPKlfzXlc2bhhWMBtt3lEKNbjxCiUsfWFRDqXXMiFv0Cu7jmivf7YE?= =?us-ascii?Q?7N/VLIc1i1rM2Qp0dUPmgFYXPNpwppuy11MMrbHiSQ/qZFZx1y+gZJ2ljp+a?= =?us-ascii?Q?Hd1DBL2sHBwlE6G+buXLh3nCix5YhhfNNN1DDk0+ZhbmcraDb+kTAlExnFgI?= =?us-ascii?Q?DGeRPVd+QiEEvMIN4LJ1xWyzi0rxfkEDWSbBC9Apbsqx6mPeMzUM//9abrHl?= =?us-ascii?Q?4qPX8Dxo9oZ5R9KStC2j12yQs26Tt/j2X8Amg+WsxWTpYOI5raH6cjcblUzh?= =?us-ascii?Q?ezwGxV5XwGGRKwFsbwnQlWF3I8uIqNjPFAlCm2lhjqTJP2hVY5s8AJzoaPAs?= =?us-ascii?Q?UhhW1q4XPUi4LvA6tqiA7AZTn7aEsYbmvD02MHlAlCP3E1Rr8azC3BOdfog8?= =?us-ascii?Q?8cOfsVYegbtdeQ/63h0kspPAK8smt0darQEsamL62QIIsmcg3g+QhLy0Cmyc?= =?us-ascii?Q?KH4IVJngoBzFrYHDwn7+q5b08Bl9afw3FP0f2udfvG8VfeaQOmMuTidBu7+c?= =?us-ascii?Q?P/+2+wNmEjZm1/gyfyCInwaWeSIwVQlzgUDMmMTLw47HpZbwgNuq5wvjzv5H?= =?us-ascii?Q?dA1D1tbWmLde0jYu8WRJdHqJ/OVblC33zu9NYI7eGPNoWeMvG/0Ra4dWOxdG?= =?us-ascii?Q?PYCzMHNeUUeFtna+c6pgDkUd?= x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_SJ0PR19MB45259F3A22D90C7C58FB603E95E49SJ0PR19MB4525namp_" MIME-Version: 1.0 X-OriginatorOrg: Dell.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SJ0PR19MB4525.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 97e6fd2e-4c11-4eb4-a60a-08d94d1f2001 X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Jul 2021 14:43:52.4774 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 945c199a-83a2-4e80-9f8c-5a91be5752dd X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: HJvPfzXlUEgm/DyL9y95kzc8tg9HoqHnTooQVsYDivEXl2/fi1fubP3+DKsfS4kqd4kWnSBLDZzNHmez1yYsKA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR19MB4640 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.391,18.0.790 definitions=2021-07-22_09:2021-07-22,2021-07-22 signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 spamscore=0 lowpriorityscore=0 adultscore=0 priorityscore=1501 mlxscore=0 mlxlogscore=243 clxscore=1011 impostorscore=0 phishscore=0 suspectscore=0 malwarescore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2104190000 definitions=main-2107220098 X-Proofpoint-GUID: HrdSLYhhWcZ97uJhZDF9j7UGStfcgQB7 X-Proofpoint-ORIG-GUID: HrdSLYhhWcZ97uJhZDF9j7UGStfcgQB7 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 suspectscore=0 bulkscore=0 spamscore=0 malwarescore=0 mlxlogscore=388 mlxscore=0 adultscore=0 phishscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2104190000 definitions=main-2107220098 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SJ0PR19MB45259F3A22D90C7C58FB603E95E49SJ0PR19MB4525namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Bug reference: 17115 When I use the psqlODBC Unicode(x64) driver for importing data into Power B= I, 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 tra= nslate 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 cor= rectly identifies the field as Boolean. Mike Lawrence Consultant Product Manager, Product Management Dell Technologies | DT Services Technologies Mike.Lawrence@Dell.com Home Office: Moorpark, CA --_000_SJ0PR19MB45259F3A22D90C7C58FB603E95E49SJ0PR19MB4525namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Bug reference:      1711= 5

 

When I use the psqlODBC Unicode(x64) driver for i= mporting data into Power BI, all three of my Boolean fields are incorrectly= identified as type Text.

I am using Unicode because of differing code page= s and the inability to translate between them with the ANSI(x64) driver. Th= is 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 M= anagement
Dell Technologies | DT Services Technologies

Mike.Lawrence@De= ll.com

Home Office:  Moorpark, CA

 

--_000_SJ0PR19MB45259F3A22D90C7C58FB603E95E49SJ0PR19MB4525namp_--