From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from cygnus.enyo.de (cygnus.enyo.de [79.140.189.114]) by sourceware.org (Postfix) with ESMTPS id CB2E13858C41 for ; Fri, 29 Dec 2023 13:02:40 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org CB2E13858C41 Authentication-Results: sourceware.org; dmarc=none (p=none dis=none) header.from=deneb.enyo.de Authentication-Results: sourceware.org; spf=pass smtp.mailfrom=deneb.enyo.de ARC-Filter: OpenARC Filter v1.0.0 sourceware.org CB2E13858C41 Authentication-Results: server2.sourceware.org; arc=none smtp.remote-ip=79.140.189.114 ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1703854963; cv=none; b=EQ6B/p0p0ICIXEffOskPc09aktL15d1YSNaMAcCsaNOdT0esCZbbFb3oL9x73Kuo1ZKHuaj6oQUT5xcynLlzcDSL2bcau/myzjrhY7iCZY7MtGc/k0Vx6V0R0ldZJl0TvPGNDe0SvCdUNZ5RCxFMnS9wKT3d/1VUNuhzsUyWH6k= ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1703854963; c=relaxed/simple; bh=NmVssrSelsJbpAVFc1swcdxh3KGuTk0RrKbrlb003iI=; h=From:To:Subject:Date:Message-ID:MIME-Version; b=K99qaQ/jTyAsojSZVR0fqBAUhCEXrp5JpqGRPLcEMdpb5iG2X+tH0ltaZ5/myC7FtEa0rVjNovSGvmnftkkz7iqh2AjXFC0mJtJFdcxif529orabm/hQXoT31mq+sZtXZnwMYLHbZCa7CaJzST1MwA2rOAuQkiMMAuX9NzMZkq4= ARC-Authentication-Results: i=1; server2.sourceware.org Received: from [172.17.203.2] (port=44517 helo=deneb.enyo.de) by albireo.enyo.de ([172.17.140.2]) with esmtps (TLS1.3:ECDHE_SECP256R1__RSA_PSS_RSAE_SHA256__AES_256_GCM:256) id 1rJCVZ-003sKc-8I; Fri, 29 Dec 2023 13:02:38 +0000 Received: from fw by deneb.enyo.de with local (Exim 4.96) (envelope-from ) id 1rJCVa-0006Dt-0V; Fri, 29 Dec 2023 14:02:38 +0100 From: Florian Weimer To: Lisa Ze via Libc-help Cc: Lisa Ze Subject: Re: Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34? References: Date: Fri, 29 Dec 2023 14:02:38 +0100 In-Reply-To: (Lisa Ze via Libc-help's message of "Tue, 26 Dec 2023 23:12:55 -0800") Message-ID: <87msttmaa9.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain X-Spam-Status: No, score=-3.3 required=5.0 tests=BAYES_00,KAM_DMARC_STATUS,SPF_HELO_NONE,SPF_PASS,TXREP,T_SCC_BODY_TEXT_LINE autolearn=ham autolearn_force=no version=3.4.6 X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on server2.sourceware.org List-Id: * Lisa Ze via Libc-help: > I upgrade my glibc version from 2.17 to 2.34. I found that my postgre > "order by" sql has the different order list. > select * from t1 order by name asc. > Before results: glibc 2.17 > A2 > A_2 > After results: glibc 2.34 > A_2 > A2 > > Could you help me to find the reasons for this? PostgreSQL has extensive documentation on this topic: Locale data changes