Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paF0j-0003tN-Ks for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 12:04:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paF0h-0004VS-LE for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 12:04:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paF0h-0004VJ-6I for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 12:04:39 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1paF0e-000529-SA for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 12:04:38 +0000 Received: by mail-ed1-x535.google.com with SMTP id g3so6067083eda.1 for ; Thu, 09 Mar 2023 04:04:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1678363475; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=VpHzRhdUicxYkzFxgxieXxbX++JwW274Lb4SGSWg1UI=; b=Ytl6JIvY1eQWVANAg9gYmKiNCcWnhobNC2YmZNlQlokFCBbtDOwDVrGt2t+V2L8fAM 3O4PCpH5dj5hvY2Sqx4unhmiqzhKYxnWdr1Jp6rwSM8ML/VoIr4ZlTGyJWUgZ8qM4YW7 HSCydDsPA8K+/jDtP01PS99dOEK9RV+YnbFDZYrDZY4tSQOy7iwWDLpoZg9DhNxLCieu MThCc9uaADKKUkKj2DQ+MLDMJ/jIYSePEzHVrQx42DfS0+2jer4svQxktNVYOjZ6WQj0 Y89CxIPmmR1OOviJmPa3wfdyEZbzlPcMD+MkLCUagZwxlj7qpn70x5rObo/XhD9g7Yfd Ll6w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678363475; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=VpHzRhdUicxYkzFxgxieXxbX++JwW274Lb4SGSWg1UI=; b=CAOisaxwkMZH5n2AQQgKUgkMk4eEn1GICbhIxblUj/NnRCLP4KdinHZq8rT3LmszcC remXtQNniaRhy0/yghLA15BvC2rq528CnhWTxHoqNyB0NOvQdzoR4gc2EGHa11hiWwpD 5A16LdSIsZuVB2sRncXK/U9IyKG6zjP0tNEfW3ieZTXfb+ay3ZFck0+cV8tMj1aNNkks Odnx5i/VEUrejbRxnADxLzyLP4Eg1ttdX5oDw0BRSpmST2gMtn6nUN2MUqHxhju8lE/N JsRTEiQBY+nbNtCRC8GRySxiFcGwFmnikvD5Hq7aCbplsJuyRp03kOFfaXkPasJdPSlr htbw== X-Gm-Message-State: AO0yUKXFymqDhdzyIcc4FDr01Z6taH1qk4PfKio/LA/FJmT1BlOyn5Lm 4VFiAnEhFKzn/ZmFZkkoPmrDag== X-Google-Smtp-Source: AK7set8QlrQzVj2tTR98OFxCIg6m8xpdphKOQEmkUGpE3XQC0pvYyS7mPYC+U2Oo9kZXPt79Pmqz5g== X-Received: by 2002:a17:907:cc1c:b0:8b1:781d:f9a8 with SMTP id uo28-20020a170907cc1c00b008b1781df9a8mr19424384ejc.72.1678363474836; Thu, 09 Mar 2023 04:04:34 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:539:1b2c:c52a:475d:310c]) by smtp.gmail.com with ESMTPSA id dx11-20020a170906a84b00b008e493b7bb61sm8700009ejb.153.2023.03.09.04.04.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Mar 2023 04:04:34 -0800 (PST) Message-ID: <5a8c87da0b8b61afd6ce12bb5cd37e87227dc7f1.camel@cybertec.at> Subject: Re: database collation "C" and "C.LATIN1" From: Laurenz Albe To: "James Pang (chaolpan)" , "pgsql-admin@lists.postgresql.org" Date: Thu, 09 Mar 2023 13:04:34 +0100 In-Reply-To: References: <9ba3e513009bada4845128d4db349346d0f956db.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-03-09 at 08:37 +0000, James Pang (chaolpan) wrote: > Both follow=C2=A0 "C"=C2=A0 collate behavior ,right?=C2=A0=20 Right. Yours, Laurenz Albe