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 1mf0Jo-0001Vm-US for pgsql-odbc@arkaria.postgresql.org; Mon, 25 Oct 2021 13:47:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mf0Jm-0004hi-Ie for pgsql-odbc@arkaria.postgresql.org; Mon, 25 Oct 2021 13:47:14 +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 1mf0Jm-0004fW-5C for pgsql-odbc@lists.postgresql.org; Mon, 25 Oct 2021 13:47:14 +0000 Received: from mail-am6eur05on2060.outbound.protection.outlook.com ([40.107.22.60] helo=EUR05-AM6-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mf0Ji-0001dU-Kp for pgsql-odbc@lists.postgresql.org; Mon, 25 Oct 2021 13:47:13 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=hxubf/l5ishJRlYxRS5xYeP2RDiJYOtwQmyJct7fg8pKuPGe85sIaTKo0zXyjELwW5dTAlAXyTZDWm9D7zQMDt4z+85Du7TbR9AHsWknUKzRzRx61fvKLw5MQYRMXr87dLMRcC4aKfQpOjbkQQu/n4hOO7HK0fVous2J6k0BrpkhItSlhxSkIoQy8pi5cqwuoTOOggr+biE1tc2anxNAfHQtORIG7J1E+vkCpoz65/7TvfJ+v9c8nOjfqdwxmb2QEz5xU4BYdNpeo5zq6zADLBN5P4uVdT4zwigKLg5AzGpCAvT/IcHJ/FNvqk3Agw7trPbavmOofr1/T+QaKEP/ew== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=bTJWoFbCZ7pQhbtJYvy9bysqZjBwmshwxmtyDkSpyhg=; b=Oq/dPzwebJ9O/ZBBKWflL6WGbuNICNtmSwOy/cBDHG7Qq8IoPcyzMtQG8YqFejrGJSBYR3BRp5rP7+lns59xnoYg2OItIYcAPeceAzV0ljwfyow3ieQs5zQ0U/3cBEMNLD2AnOxQAM5i8Hx3U9hikuGtNRbXHknIZpK1qIWP2apWMo4JZILeDEEjQ845xHMITaqcyX7g0BiFvtBwTyHJA2X2vqX0yVoFdeFGZCzu8/RfpKPnPi9vFh6dL7cUwTTAabvDCD1gFmP6JrLQE56Rc8w3XxRm0RsJUHuL4h5XIvjAR4hsQvJRCYR9DakIR70ujNviI/d2yClKntgVZeHm1A== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=openbooking.ch; dmarc=pass action=none header.from=openbooking.ch; dkim=pass header.d=openbooking.ch; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pixeltex.onmicrosoft.com; s=selector2-pixeltex-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=bTJWoFbCZ7pQhbtJYvy9bysqZjBwmshwxmtyDkSpyhg=; b=ekDQ2ui2NINPJjygb6xtCD96u0/gUmxJT0JclMheIE1g15+C0W/i9iXjmRhcKxgmnSTpY/0AdYhNajmfIrKBztUTi7le+K3x2Ix86tW9LcvUXRWIorn9FwwbeDJC1eOaVO3fqq3V378g+S2H8u9T8HSg8Qc+aTjYDV1cfwBCknI= Received: from PA4PR08MB5886.eurprd08.prod.outlook.com (2603:10a6:102:e2::19) by PR3PR08MB5769.eurprd08.prod.outlook.com (2603:10a6:102:91::24) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4628.16; Mon, 25 Oct 2021 13:47:08 +0000 Received: from PA4PR08MB5886.eurprd08.prod.outlook.com ([fe80::c401:33a6:ac83:976c]) by PA4PR08MB5886.eurprd08.prod.outlook.com ([fe80::c401:33a6:ac83:976c%6]) with mapi id 15.20.4628.020; Mon, 25 Oct 2021 13:47:07 +0000 From: Louis Brauer To: "pgsql-odbc@lists.postgresql.org" Subject: Issues with mixedCase columns Thread-Topic: Issues with mixedCase columns Thread-Index: AdfJpo6MdL6FcTakQLCYMkysIfo5dA== Date: Mon, 25 Oct 2021 13:47:07 +0000 Message-ID: Accept-Language: en-US, de-DE Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=openbooking.ch; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 86a09569-364a-45d7-47c6-08d997bdefe6 x-ms-traffictypediagnostic: PR3PR08MB5769: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:5516; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: OHVGooMdcIqO7zaqnqxVi+ggDR9hlzoSSWQyMYKGJpTxwaY9pQPUmHfz/U+FYkysLjf/wVcI4GgPr7ybHWIOEieZrsAEKyBBaXtWSIFHdIrsO5D1mDo9CiXp6L1Agu/ffmdVK1js6ShffbX0GTQmulgDc6IzfQuZQjRgDFc3AfS1uDPObKjtfTFodFl+w27ToGLTL98u1RphKjL13wAGG7BWCEmWBwdiNT1HOJ+u5Uuh4sGHTo8js1FtzCq2zHnLjJgY2IeS7Lg9QYPgM6cIUB3mmo3e6N+/P7R9q7X2NwN4le1Kc4+OZepuGmEWZS0RJgmZ8aWwd1/I8xYmUI3xXc7nO8AGwa0IEnPSK/eNO2e6n/QnfzES4CRhdQPHLfMoc7I2oiMHbreW00gfMRCy4W7WfgsCw+oy0XxLcmtk0b//g3xnyX4etUkSnxS2EAmNp679Jn8Kd3YSJsnbvumxBORFd1Fvox9Rnm3EbDpHYDGrvPjptBsoowYAMcYU5wGJ/6OJmcnLtDnSS9hizHGDgOBkq5QRKrGZEfpB9/ySVJPF9uwimy5iJEtHRsLhD780t53Bw724ywwyVYXGdg+GEaQWBS2Zv36gWIUVWNEHRMgPOkdV4uz87yC7j0J7MFrdJ2exs6NkfNW2+qgsgXY3sDyxDcLiwnr+1ytr0+q8JQnLUYdXeioBocW0JguW/APvDC/l+N6SG9U7IRp1PYvaaw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PA4PR08MB5886.eurprd08.prod.outlook.com;PTR:;CAT:NONE;SFS:(366004)(376002)(39830400003)(346002)(396003)(136003)(34036004)(2906002)(7696005)(55016002)(86362001)(6506007)(8676002)(71200400001)(38070700005)(4744005)(9686003)(316002)(38100700002)(76116006)(6916009)(5660300002)(508600001)(3480700007)(26005)(66446008)(66476007)(66946007)(33656002)(8936002)(122000001)(186003)(66556008)(64756008)(52536014);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?W6XrJU+w5ytdaf0ZTqOKXEFo3Px3qW748wrT/qPAdBQHFDtLAczvc3mu1hwK?= =?us-ascii?Q?PclUUmj3PjU4822Pbu1Hx34QLjxRaU/HldBSpJvHf1TqHbWj1WPRd2IhJd0O?= =?us-ascii?Q?Whj9LKVvfvZ/FGfpFmCHI5JpCx2aqPYKQj0iAdxU7Lqch1o8JIO/+qwUva8c?= =?us-ascii?Q?ouYLvJ9fjZwQGppkcD78QNpn2nXPU9CU1XYxmg+SKu8h/SKqg2U6cbz8YdXZ?= =?us-ascii?Q?5XHEXDbN7Vb82zsmPyH5UNqWKvO5AX85tt/3bSJbwopntxWrrAYNYucWHocU?= =?us-ascii?Q?ITTwa07pSUSct0UXaJVYGn8S3nVBSRfhZVX2sYCP9RcFqFcIKmezTd1qz/mj?= =?us-ascii?Q?wrnwHEret6RK4iKvUirO2qBKfaC1nD2tGWAaKcDKomkXZ/Sd+/GjS/3XoVNB?= =?us-ascii?Q?1jE5XaxJSCp0liVz2C8DppVra1tfHeW1H1mxhF6+yCiAEvo2Cmq7Tnszt5dY?= =?us-ascii?Q?UzVjd77Z+IT0T5Z6wIHi/nIyeUkOc8M2DsUMwbFBDFQzKMbd88W6snnv3ao+?= =?us-ascii?Q?aLMaVI5r1IlQZz4XWzb7givQTxc9WXgFhv4vAhapEghAK67LgKQRyfOvpsqo?= =?us-ascii?Q?kUhOQlWPvzvDIWAKOWyG4pjUzQ62gfiIeURlDH2s7RMiMM4y1TELPlXoHtfV?= =?us-ascii?Q?JcPLrEfMDHM/CG67Iap8Vobo0kksfI63CKu6TDPpBmR9tY6uVplXl8JEh6U8?= =?us-ascii?Q?0SXcDACoQTVw/4FGkk5bphaIltrEzqcuAbWtp9zMMMVnIL8pYuJB0ST5e7jy?= =?us-ascii?Q?OtZOur4mOFgP5XiijLqGEUVU5bXaVT+h8X0G1eIXfD+xXh5yOgxf/Q6lMbfB?= =?us-ascii?Q?GKHoVrYCXyQVXWK6v2UQy/oj4GslD6KXM++XehGUETRBLKdvRmHhS0KZdU+4?= =?us-ascii?Q?6Yhv1yq3DzKMvgaLfF9SKJXauTdHdWY4YIVy2DsHeNgutedEn5e/htiNbv37?= =?us-ascii?Q?7Rj99ouw3PoNNSTIOl6HpJiSQTk0m3yjqPZ/x+bGCT7sQpOrOj35ub08jOd4?= =?us-ascii?Q?NeoSz2RZ5w4ARjen2eLaktHy0+Oj0G1rah+S+qfkgDBUuQHZsQPi2oxq8vQx?= =?us-ascii?Q?FfvSQ3iaE0/LR0vrhkWOd704WHNw66Tc0b1pClDLdqoufpmC1KgB0v6UkAmk?= =?us-ascii?Q?3BSilc5rz6UDvfSxl18Cdrl/Z7ZCuM+zGBGamwx8sMQN1ny9s/LXtfiFenW1?= =?us-ascii?Q?mlF2ppl+mToXgkpZJWa2HaI6QVsvU6c7cdRBF6mGSB7PmAcFN4fdL381Ij3S?= =?us-ascii?Q?lTB/n6jxPYj/3OuGRb7/XRIY9jlksERddUka/gwInSEjcYgVX51S6d3rg74z?= =?us-ascii?Q?3wADq+0P5uiEDvFs6pwlWA2S/n3YNoqBiNIaimO8iDMvGAysdx4e/PjzD34Q?= =?us-ascii?Q?SVPcKKLTI2qwzCu+QLsAnxEp7U5zdetWfRVnoldWuoUEBHQ4WPN3fayfe36O?= =?us-ascii?Q?tEhCgPtpuNyu6c5TcEv+ao5OQ1duA/W4TGIuQioqI+N2KGYPbYWEBD3UvgJe?= =?us-ascii?Q?EYhX9q9BxI0oyVVL8HSvkbKJY8izfvrJhzIphHm/S8ha38vkqt3Z4R1GCX0A?= =?us-ascii?Q?y2zVLpA4dpbiUxlFIpdLNZqOLS1Yu6UScvQnGvHHubyBCETbbr01SOvG3Soh?= =?us-ascii?Q?JQ=3D=3D?= Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: openbooking.ch X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PA4PR08MB5886.eurprd08.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 86a09569-364a-45d7-47c6-08d997bdefe6 X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Oct 2021 13:47:07.7900 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6581adf8-f144-400f-8dcd-b224a1560f69 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: AyZq0gb7xIZu7n1pwNqORfbTvQLOL9kqYEx3PItkbdkrY5dxpaPzPVyRivSTcoVDq8qUoR1dzPDOD/S3l+JXVg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR08MB5769 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi there! I've a legacy table with the following columns: id group createdAt When issuing a query using PG ODBC with Visual Studio, the "group" column g= ettings properly quoted, but "createdAt" not, so the query fails with "ERRO= R: column "createdat" does not exist. Is that an issue with the ODBC driver or Visual Studio? - Louis