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 1qeENL-006Bjo-2B for pgsql-general@arkaria.postgresql.org; Thu, 07 Sep 2023 12:44: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 1qeENJ-001utF-O5 for pgsql-general@arkaria.postgresql.org; Thu, 07 Sep 2023 12:44: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 1qeENJ-001usr-3L for pgsql-general@lists.postgresql.org; Thu, 07 Sep 2023 12:44:45 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qeENE-003fqI-DT for pgsql-general@lists.postgresql.org; Thu, 07 Sep 2023 12:44:44 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-58cd9d9dbf5so12310267b3.0 for ; Thu, 07 Sep 2023 05:44:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1694090678; x=1694695478; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:subject:from:references:to :content-language:user-agent:mime-version:date:message-id:from:to:cc :subject:date:message-id:reply-to; bh=7+LVX4kCG731JfNd3FNYrJHHZLnlWrPOxAAx+At3ZVo=; b=rYU/jGQdTjqMshUVxXAkT98+xxnVski0BlZUGpdCqPJaelqrdHsBuIF7bRJgzu49mz 1AaQ8F/V2EYdLnMfbnXUrLbQUFoOWUPFmyw+mlFjidm5C0ukjvkSp5hvpIZVyoKLXCIQ 9V4ZMr5zs1WTNQFPUozv5KK+RMI7iJKUPE0773jXhk5oQ6hdyvQu93oJMQXvhAg56Ah/ RkM/V7rJ91u5XIQSLbZxfdrL1k3kdnh8+P8tsZ2JLvMmhIwN6jO1MGQuqW8ATpTdFLlL qASKW/SyUD958MR/ZHLUrQwkFGJDIP8OXGPBAl69zbbjZNkfCcG8m3721HPSzJpHWYb9 fVfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1694090678; x=1694695478; h=content-transfer-encoding:in-reply-to:subject:from:references:to :content-language:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=7+LVX4kCG731JfNd3FNYrJHHZLnlWrPOxAAx+At3ZVo=; b=Ag+8uL2Z9ReR7Cmz+hXlbkggpTIrEByMLIoYElgpYtNGMzqhevf4l1EInZyOUIe/Jn 9Hu2ON9lefoSbRhwM9dnn+Co+YgZMx1sBBYQEo7x+gdJhzamIljy2lJB8caXeDeZ1hKD nfGCgyw5XwoTs2FxMNG8AYnC0VIR6hAus+JJtG+eRZT5WNMVW9zEgnIaeLfOFeLonz0L A4S8JUGiyGJfdnczu1Fv3MVz+K/W/qI043lYkKGzp+pvKaTOchCgX5d8pF5SHAbH+2wy 3t5o1qgsm4k3GHnnN6yaU0+B1AFjLLGDsC6a3zyQb72dexAolV2Y9vAUgMcVmpnr0LLq K+ag== X-Gm-Message-State: AOJu0YzCK7nmzab+GNotQyzlRuxbaPKsdwYx6EdCt60Ask0fjq1XNGQN 5BFeQDwPlo6kqP9E6P5INJ+6F/s3xczFm3onlQE= X-Google-Smtp-Source: AGHT+IHW6rOt0b2Go9E34BwRxgJTd/79Vq2BDr+DkdE0yfTzUnfGxV9oneY2mk/1XMjbDPDvX1k1Rg== X-Received: by 2002:a0d:e249:0:b0:583:821b:603a with SMTP id l70-20020a0de249000000b00583821b603amr2892207ywe.20.1694090678521; Thu, 07 Sep 2023 05:44:38 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id m125-20020a0de383000000b00583d44b4b30sm4297876ywe.99.2023.09.07.05.44.38 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 07 Sep 2023 05:44:38 -0700 (PDT) Message-ID: <80932f61-8564-7533-eb65-d91916328cd1@joeconway.com> Date: Thu, 7 Sep 2023 08:44:37 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.15.0 Content-Language: en-US To: Helmut Bender , pgsql-general@lists.postgresql.org References: <1507834.1694008417@sss.pgh.pa.us> <7934e62f-516b-820d-1d37-7b915f5dd7a4@helmut-bender.de> From: Joe Conway Subject: =?UTF-8?Q?Re=3a_postgreSQL_UPPER_Method_is_converting_the_character?= =?UTF-8?B?ICLCtSIgaW50byAiTSI=?= In-Reply-To: <7934e62f-516b-820d-1d37-7b915f5dd7a4@helmut-bender.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/6/23 11:22, Helmut Bender wrote: > Am 06.09.23 um 16:04 schrieb Sai Teja: >> In my local it is windows OS and locale is English_united_states.1252 >> and in local it is converting as expected ( testµ into TESTµ) > > You wrote PostgreSQL is hosted on an utf-8 system. That's why it's > working different. > > And be careful: the M isn't the uppercase latin m, but in fact the > uppercase µ (U+039C in unicode)! If you would compare it to latin > alphabet 'TESTM' it would be different. Yep, there are interactions between the encoding used by your terminal, the server encoding, and the client encoding. You have to be particularly careful when cutting and pasting that the client encoding and your terminal encoding match or you can get surprising results. -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com