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 1qdvWz-005BxT-TK for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 16:37:30 +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 1qdvWy-00BeGg-Ni for pgsql-general@arkaria.postgresql.org; Wed, 06 Sep 2023 16:37:28 +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 1qdvWy-00BeGO-9W for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 16:37:28 +0000 Received: from mout-u-107.mailbox.org ([80.241.59.207]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdvWu-003Rwx-Eb for pgsql-general@lists.postgresql.org; Wed, 06 Sep 2023 16:37:27 +0000 Received: from smtp102.mailbox.org (smtp102.mailbox.org [IPv6:2001:67c:2050:b231:465::102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4Rgp1q59ygz9sQc; Wed, 6 Sep 2023 18:37:19 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ewie.name; s=MBO0001; t=1694018239; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=Tmr6akeoUbSQe2IBVoU/0YQ8BdxEM+GbyxQsIFAOm3c=; b=ujv2ZfldaN/0Tltyb2itPwBMWoi7GYhDG5FX2hsWIr95NUOf+nRxinnkgqV/DCgi5edxJm mlCevarab/L8yOybPUUE3TU7JON+YSvkDiEFa7ZL0yzXxRLvh/UiBzLs+STlV2FDDwo35a sRjE2jBjv0Bu5nscRX56lx5m2aryUpvRYzOr3MejBHrg2TvqSs6s2JTMMQ2tnM/1NgDcX5 ZyKYDf2HOWvBPuZ3J4j7pM3MjwSwZeOoQLPvyDvItPxeMV+qJmixuwowdSIv2VHZqVTjWG sIfIRKx0sjwcJgTiXri7l/cMfDgzM24Ihm4SwCzqf+4OnMo23H0dqoLeVBCJdw== Date: Wed, 6 Sep 2023 18:37:19 +0200 (CEST) From: Erik Wienhold To: Sai Teja , pgsql-general@lists.postgresql.org Message-ID: <116684458.10688.1694018239289@office.mailbox.org> In-Reply-To: References: <1507834.1694008417@sss.pgh.pa.us> Subject: =?UTF-8?Q?Re:_postgreSQL_UPPER_Method_is_con?= =?UTF-8?Q?verting_the_character_"=C2=B5"_into_"M"?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Priority: 3 Importance: Normal X-Rspamd-Queue-Id: 4Rgp1q59ygz9sQc List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 06/09/2023 18:04 CEST Sai Teja wrote: > When I'm trying the below command > Select UPPER('Mass') > I'm getting MASS as output . > But when I created the column with generated always constraint > For example > Alter table xyz add column xyz varchar(800) generated always as (UPPER(co= ntent)) stored > > Here content is original string coming from the table > The output is coming as '=C2=B5ass" when I am selecting the data from the= table Please provide the statements (CREATE TABLE, INSERT, and SELECT) to reprodu= ce it otherwise it's hard to analyze what's going on. Homoglyphs are one explanation if you get '=C2=B5ass' from the generated co= lumn as described. Another explanation is that you just selected a different colum= n. -- Erik