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 1paBeo-0002MH-Gm for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 08:29:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paBen-0005mO-6V for pgsql-admin@arkaria.postgresql.org; Thu, 09 Mar 2023 08:29:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paBem-0005mF-Mw for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 08:29:48 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1paBej-00076z-Ss for pgsql-admin@lists.postgresql.org; Thu, 09 Mar 2023 08:29:48 +0000 Received: by mail-ed1-x52d.google.com with SMTP id j11so3851933edq.4 for ; Thu, 09 Mar 2023 00:29:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1678350585; 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=PMDQx+cRNX+GpkDcia/LO8CeORX3keo6TvUVdMiBHcM=; b=jNAucUkyZaBTeg6nJw/B8ojxBxlIDBG/hwXHfxx9GTNST4qn3e6OLqP9ulVKlso3KX dXKaAPm1HRnBMk+6/qne7/ZQGPwKmF2jhKl1qBQ1HKOLn77FUAnGcmCMH5f/EMCtMhWY BjVcrO3cbwW4GinpYg8NlMwJuiVTlO3p962Nf+C3DsHYIAQgkmP9I7tSBtmZhBEhmKNI /cXnm8DNkWvhqEB0N4B0t11gkHVZLlqvVkNdcm9CmD3DWkAc8T/EX2dahgf7teooSwy2 AL4shWH6UodNXCa5S1On9490TY5i8Z1+tDAUHU3yyoKz5wDw7lEWEMgYBb7W13uaxvTJ Tl/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678350585; 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=PMDQx+cRNX+GpkDcia/LO8CeORX3keo6TvUVdMiBHcM=; b=6i4Ibh8Kjoc/88eFsJbge7hgy3+Xr9TEvaeuBZNG1vSW+yEy4Y7zLWJW2dMKM4bthF 6R7DP61Zm+o6EooVK/09TJhROvtSUmF2OlGagvivdlD0Dugp1DxWtB895V+33YQD3MIK /4GnhZwh8A+u1ponjnNGFzaq9OBVeZlJ8DXM9RYZpIWIQSaGW2AyYqfpWaatc4QeudKs tZfyq05NJB8CwsiVKndFch6NeiW+BLTRtRiej6zx+IxsRCYOEO0aM+AUrv4BfabEpdbM sKt+Sa8L2BkNxokeuuP7+9KeSZ0GOqZRJIROjQEn8+odL5vm5IzRKcxfXq5JpVq71LrR YVug== X-Gm-Message-State: AO0yUKU4l6ZZfZQBLsKYe16UM9oCXIuG5edauHF/tajhQrgwpoE03PbN obbFqcWAA+HOdd98WzEF1rV6Aw== X-Google-Smtp-Source: AK7set+H4i3Cgyay1qijO1Fdh95YAtubV0W6qjBU1qkDh8PhGEjOw9DKCno7Y7G6wQ7p+vYIqmveng== X-Received: by 2002:aa7:df96:0:b0:4b1:b71d:cbfe with SMTP id b22-20020aa7df96000000b004b1b71dcbfemr19798421edy.2.1678350584834; Thu, 09 Mar 2023 00:29:44 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:539:1b2c:c52a:475d:310c]) by smtp.gmail.com with ESMTPSA id va12-20020a17090711cc00b008b11ba87bf4sm8461334ejb.209.2023.03.09.00.29.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Mar 2023 00:29:44 -0800 (PST) Message-ID: <9ba3e513009bada4845128d4db349346d0f956db.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 09:29:43 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 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 T24gVGh1LCAyMDIzLTAzLTA5IGF0IDA4OjIyICswMDAwLCBKYW1lcyBQYW5nIChjaGFvbHBhbikg d3JvdGU6Cj4gV2UgY3JlYXRlIG9uZSBkYXRhYmFzZSB3aXRoIGNvbGxhdGU9IOKAnEMuTEFUSU4x 4oCdLCBhbnkgZGlmZmVyZW5jZSBiZXR3ZWVuIOKAnEPigJ0gYW5kIOKAnEMuTEFUSU4x4oCdID8K PiBkYXRhYmFzZSBlbmNvZGluZyBpcyDigJxMQVRJTjHigJ0uCj4gwqAKPiAgIG9pZMKgIHzCoMKg wqDCoMKgwqDCoCBjb2xsbmFtZcKgwqDCoMKgwqDCoMKgIHwgY29sbGVuY29kaW5nIHzCoMKgIGNv bGxjb2xsYXRlwqDCoMKgIHzCoMKgwqAgY29sbGN0eXBlwqDCoMKgwqAgfCBjb2xsdmVyc2lvbgo+ IC0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLQo+ICDCoCA5NTAgfCBD wqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIHzCoMKgwqDCoMKgwqDC oMKgwqDCoCAtMSB8IEPCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgfCBDwqDCoMKgwqDC oMKgwqDCoMKgwqDCoMKgwqDCoMKgIHwKPiAgMTIzMjggfCBDLmxhdGluMcKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqAgfMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgOCB8IEMubGF0aW4xwqDCoMKg wqDCoMKgwqDCoCB8IEMubGF0aW4xwqDCoMKgwqAgICAgIHwKClRoZSBkaWZmZXJlbmNlIGlzIGEg dGVjaG5pY2FsaXR5OiAiQyIgaXMgZW5jb2RpbmcgYWdub3N0aWMgKC0xKSBhbmQgY2FuIGJlIHVz ZWQgd2l0aAphbnkgZW5jb2RpbmcsIHdoaWxlICJDLmxhdGluMSIgY2FuIG9ubHkgYmUgdXNlZCB3 aXRoIGVuY29kaW5nIExBVElOMSAoOCkuClRoZSBiZWhhdmlvciBpcyB0aGUgc2FtZS4KCllvdXJz LApMYXVyZW56IEFsYmUK