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 1lFYIe-0001uJ-PJ for pgsql-odbc@arkaria.postgresql.org; Fri, 26 Feb 2021 08:16:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lFYIa-00044k-6N for pgsql-odbc@arkaria.postgresql.org; Fri, 26 Feb 2021 08:16:32 +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 1lFNq7-0000SR-E1 for pgsql-odbc@lists.postgresql.org; Thu, 25 Feb 2021 21:06:27 +0000 Received: from portal-smtp-out.hot.ee ([194.126.101.125]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lFNq4-0006n1-Ef for pgsql-odbc@lists.postgresql.org; Thu, 25 Feb 2021 21:06:26 +0000 Received: from localhost (localhost [127.0.0.1]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 1A5561DAB for ; Thu, 25 Feb 2021 23:06:23 +0200 (EET) X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee Received: from portal-smtp-out.hot.ee ([127.0.0.1]) by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id sxSjs3qSsTvI for ; Thu, 25 Feb 2021 23:06:20 +0200 (EET) Received: from mail.hot.ee (hot-relayhost2.estpak.ee [213.180.2.80]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 777D41DA5 for ; Thu, 25 Feb 2021 23:06:20 +0200 (EET) To: pgsql-odbc@lists.postgresql.org From: Andrus Subject: Using special characters in password Message-ID: <607647d2-ccf0-c8fd-c69e-b715e3202db3@hot.ee> Date: Thu, 25 Feb 2021 23:06:15 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------200BB55D99E3D3B3A1D63221" Content-Language: et List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------200BB55D99E3D3B3A1D63221 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Hi! Using special characters in connection string password like DRIVER={PostgreSQL Unicode};PWD=pü or in url encoded form DRIVER={PostgreSQL Unicode};PWD=p%C3%BC throws password error. According to https://www.postgresql-archive.org/Problem-with-special-characters-in-password-when-using-SQLDriverConnect-td5755239.html and https://www.url-encode-decode.com PWD=p%C3%BC should accepted as pü Using Postgres 13.1 with  32-bit psqlodbc driver  13.00.0000  in Windows 10 non-unicode application where system locale is Windows-1257  (Baltic Windows) How to use special charcters in passwords ? --------------200BB55D99E3D3B3A1D63221 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Hi!

Using special characters in connection string password like

DRIVER={PostgreSQL Unicode};PWD=pü

or in url encoded form

DRIVER={PostgreSQL Unicode};PWD=p%C3%BC

throws password error.

According to

https://www.postgresql-archive.org/Problem-with-special-characters-in-password-when-using-SQLDriverConnect-td5755239.html

and

https://www.url-encode-decode.com

PWD=p%C3%BC 

should accepted as pü

Using Postgres 13.1 with  32-bit psqlodbc driver  13.00.0000  in Windows 10 non-unicode application where system locale is Windows-1257  (Baltic Windows)

How to use special charcters in passwords ?
--------------200BB55D99E3D3B3A1D63221--