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 1qdsyZ-0054R7-Ul for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 13:53:47 +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 1qdsyX-00Ad9o-Kn for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 13:53:45 +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 1qdsyX-00Ad9V-8e for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 13:53:45 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdsyS-003QVW-M4 for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 13:53:44 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 386DrbBD1507835; Wed, 6 Sep 2023 09:53:37 -0400 From: Tom Lane To: Sai Teja cc: pgsql-general@lists.postgresql.org Subject: =?UTF-8?Q?Re:_postgreSQL_UPPER_Method_is_converting_the_character?= =?UTF-8?Q?_"=C2=B5"_into_"M"?= In-reply-to: References: Comments: In-reply-to Sai Teja message dated "Wed, 06 Sep 2023 19:12:46 +0530" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <1507833.1694008417.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Wed, 06 Sep 2023 09:53:37 -0400 Message-ID: <1507834.1694008417@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Sai Teja writes: > I am using UPPER document name for converting the text from lower case into > upper case. > But here for the below example > Command:- select UPPER(testµ) > Input :- testµ > Output:- TESTM > Expected output :- TESTµ According to https://en.wikipedia.org/wiki/Greek_alphabet the upper-case form of µ (mu) is in fact M, so I'm not sure what problem you have with this. But in any case, you are complaining in the wrong place. This conversion is determined by the rules of the selected locale. If you don't like it, choose another locale, or make your own, or try to persuade the glibc maintainers that they are wrong. regards, tom lane