Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdyMu-005MVS-OI for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 19:39:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qdyMt-00CpUA-Ir for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 19:39:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdyMt-00CpTx-5l for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 19:39:14 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdyMp-003TjY-N6 for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 19:39:14 +0000 Received: from karst (larco.ioguix.net [78.202.0.6]) by mail.dalibo.com (Postfix) with ESMTPSA id 7ED8B1F7B4; Wed, 6 Sep 2023 21:39:09 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1694029149; bh=s44kchcvuCmcymt8lzpTsVLXMBM7BL2+KdrbB/0nj7g=; h=Date:From:To:Cc:Subject:In-Reply-To:References:From; b=CKbqA1FxC79jkWKBh6rI+ZK7rPVYc0IeTNQjFW4DcuR+gXK+cfzgVGzv6+n+7ELgT 78m6a7spZp11b1pdMqVNhke9DeedYLhaB3XVAdJStp2NB1kWIGgAHYE67MoJUyZMYE P+4IteNaePrO+MVS4QvQQjRy6cEDB7QxBBqECo/c= Date: Wed, 6 Sep 2023 21:39:08 +0200 From: Jehan-Guillaume de Rorthais To: Sai Teja Cc: pgsql-general@lists.postgresql.org Subject: Re: postgreSQL UPPER Method is converting the character =?UTF-8?B?IsK1Ig==?= into "M" Message-ID: <20230906213908.465e77cb@karst> In-Reply-To: References: <1507834.1694008417@sss.pgh.pa.us> Organization: Dalibo MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 6 Sep 2023 19:34:40 +0530 Sai Teja wrote: > In my local it is windows OS and locale is English_united_states.1252 and > in local it is converting as expected ( test=C2=B5 into TEST=C2=B5) I'm not familiar with PostgreSQL under Windows. Maybe collation from locale "English_united_states.1252" is available in PostgreSQL? Could you try crea= ting a database/table/column using this collation? Or just look at available collations using: select collname from pg_collation ++