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 1ppuzi-00037k-CD for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 17:56:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppuzf-0007aH-WB for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 17:56:24 +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 1ppuzf-0007a8-LU for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 17:56:23 +0000 Received: from mail-qv1-xf30.google.com ([2607:f8b0:4864:20::f30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppuzZ-0017UG-Qo for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 17:56:22 +0000 Received: by mail-qv1-xf30.google.com with SMTP id 6a1803df08f44-5ef6197ea51so10563076d6.1 for ; Fri, 21 Apr 2023 10:56:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pcorp-us.20221208.gappssmtp.com; s=20221208; t=1682099777; x=1684691777; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:cc:to :from:from:to:cc:subject:date:message-id:reply-to; bh=0C6ZE73mks/ObDuC/uctbKWwmcDZ1JY1qwFpgxvdzA8=; b=nGZ7oDFZ6Uh4BAL9aWjzj7vXxTlvJxgI41GEiY+bi8OJzwh1ISIHehIG4OBswC8HDN gi4Ho8YhqufIQM4RJY+J+hZvx12qQ0jKT1JIZJLOrW9tu0WP6O4xCKmKwiSGBVxu+Zfr r4AOtC9YJ2X3GBXbzMObTwT8JfkbjriAFNWTpEG0h7gtSIPAVAv8b9VJfoDr69OIeP5m uivZqh5RZANlUFcnRqae9lGj35v/TwUykdrUNeR7VFK8rnMRdhgjUfz3cc9FsPPWjShB YIRs1laaQlIbib/NNh12nDwWgua4/5PqeEWUz4LxiAnUlJUXBUewSSYzxa6v5xYIQwG+ fHvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682099777; x=1684691777; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:cc:to :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0C6ZE73mks/ObDuC/uctbKWwmcDZ1JY1qwFpgxvdzA8=; b=Z6w1c8aqMdsJ0wuuIHbgyNbhm1UjZUodXBGbz4cTvFFr8KGiLFZqb/k2XQBgRQ4E8m eHQWCGmPsOxWcLalrlLyKsE47MnoqKVZbe4G9kJudscV3qPRWYIPCzo8lKUWYelEIxbg cYc6rtOtyTRRULw/kCjOUFgKqU6o5hYxqbu7sZ19kopyo2lLseFhFHzBECS0whFWTVTv SRqnuClhjpJJnpymnvRsC2P1BBTPNvaQo/M9d34ycNSkCLT94ux+Hc2vIbkDeGdAJ/S9 y2xAMiLi/duqlU9AyosjjEsPOlU0xNfddxjVTsElq2e/IicF/pR+AbzHgwvqkPDNynIi 5Cug== X-Gm-Message-State: AAQBX9e0cFa3n6gwcjHwFuCblc2lDxDNF1WSduvk6pHj3i3jcQ1rd4i0 zC3nPs8RkI+Sw9+cWM/eivTxCA== X-Google-Smtp-Source: AKy350bPqyuwSp/aUxoHMYm710ptlViPF5LxzULjd9Xz10cqxIbpmkMb/6AlaFfRdWUA3PVPxHPWvw== X-Received: by 2002:a05:6214:19e5:b0:5ef:8b82:8318 with SMTP id q5-20020a05621419e500b005ef8b828318mr10876206qvc.42.1682099776792; Fri, 21 Apr 2023 10:56:16 -0700 (PDT) Received: from F (50-78-240-110-static.hfc.comcastbusiness.net. [50.78.240.110]) by smtp.gmail.com with ESMTPSA id j5-20020a0ce005000000b00605b0553ae7sm598193qvk.120.2023.04.21.10.56.15 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 21 Apr 2023 10:56:16 -0700 (PDT) From: "Regina Obe" To: "'Tom Lane'" Cc: "'Peter Eisentraut'" , "'Sandro Santilli'" , , "'Jeff Davis'" References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com> <3365333.1682098091@sss.pgh.pa.us> <002d01d97477$f0395640$d0ac02c0$@pcorp.us> <3367226.1682099185@sss.pgh.pa.us> In-Reply-To: <3367226.1682099185@sss.pgh.pa.us> Subject: RE: Order changes in PG16 since ICU introduction Date: Fri, 21 Apr 2023 13:56:14 -0400 Message-ID: <003b01d9747a$910471c0$b30d5540$@pcorp.us> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQGxk+8S/MfoZUDGLFz42A+I7+xfAAHR8HzHAhsEYz4Bynr6awHasdxCAp1gB3YBWXyFza8phHAw Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > CREATE DATABASE test TEMPLATE=template0 ENCODING = 'UTF8' > LC_COLLATE = 'C' > > LC_CTYPE = 'C'; > > As has been pointed out already, setting LC_COLLATE/LC_CTYPE is > meaningless when the locale provider is ICU. You need to look at what ICU > locale is being chosen, or force it with LOCALE = 'C'. > > regards, tom lane Okay got it was on IRC with RhodiumToad and he suggested: CREATE DATABASE test2 TEMPLATE=template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' ICU_LOCALE='C'; Which gives expected result: SELECT '+' < '-' ; -- true but gives me a notice: NOTICE: using standard form "en-US-u-va-posix" for locale "C"