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 1r7zXs-007kG1-An for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Nov 2023 14:58:40 +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 1r7zXr-005ZoN-0z for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Nov 2023 14:58:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7zXq-005ZoF-Ot for pgsql-bugs@lists.postgresql.org; Tue, 28 Nov 2023 14:58:38 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r7zXo-007mmo-2B for pgsql-bugs@lists.postgresql.org; Tue, 28 Nov 2023 14:58:37 +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 3ASEwZlj4143552; Tue, 28 Nov 2023 09:58:35 -0500 From: Tom Lane To: shailesh.totale@sailpoint.com cc: pgsql-bugs@lists.postgresql.org Subject: =?UTF-8?Q?Re:_BUG_#18216:_Unaccent_function_is_unable_to_remove_a?= =?UTF-8?Q?ccents_(diacritic_signs)_from_Japanese_character_'?= =?UTF-8?Q?=E3=83=89'?= In-reply-to: <18216-1e37bb8229aeab67@postgresql.org> References: <18216-1e37bb8229aeab67@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Tue, 28 Nov 2023 07:15:41 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4143550.1701183515.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 28 Nov 2023 09:58:35 -0500 Message-ID: <4143551.1701183515@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Bug reporting form writes: > PostgreSQL's unaccent module does not use Unicode normalisation, but onl= y a > simple search-and-replace dictionary. The dictionary, unaccent.rules > (https://github.com/postgres/postgres/blob/master/contrib/unaccent/unacc= ent.rules) > , does not contain these Japanese characters, thus its unable to rem= ove > the diacritic signs. Can someone please guide when we can expect these > Japanese characters will be added. unaccent.rules, as distributed, is just an example. It is not meant to be exhaustive or authoritative. Feel free to add your own entries to your copy. regards, tom lane