Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1ZSt-0007VA-RE for pgsql-admin@arkaria.postgresql.org; Sun, 16 Sep 2018 16:00:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1ZSp-0006vl-8A for pgsql-admin@arkaria.postgresql.org; Sun, 16 Sep 2018 15:59:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1ZSp-0006ve-0Z for pgsql-admin@lists.postgresql.org; Sun, 16 Sep 2018 15:59:59 +0000 Received: from mx1.mailbox.org ([80.241.60.212]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g1ZSk-0004m6-Ot for pgsql-admin@postgresql.org; Sun, 16 Sep 2018 15:59:58 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [80.241.60.240]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.mailbox.org (Postfix) with ESMTPS id C58664998F; Sun, 16 Sep 2018 17:59:52 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp1.mailbox.org ([80.241.60.240]) by hefe.heinlein-support.de (hefe.heinlein-support.de [91.198.250.172]) (amavisd-new, port 10030) with ESMTP id BivFcnUUXnLI; Sun, 16 Sep 2018 17:59:21 +0200 (CEST) Message-ID: <2637a385ee9b301b503b728fd8b1f41cab3a7e5b.camel@cybertec.at> Subject: Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x From: Laurenz Albe To: Debraj Manna Cc: pgsql-admin Date: Sun, 16 Sep 2018 17:59:19 +0200 In-Reply-To: References: <0f5ad1359ca05bb3e77c346aa012b1df1d8f5429.camel@cybertec.at> Organization: Cybertec Content-Type: text/plain; charset="UTF-8" Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Debraj Manna wrote: > Will there be any other difference like in terms of index size, etc? The size will be the same, just the ordering will be different. > Is there any link that I can refer that provides more details about the differences? Maybe unicode.org has some material... Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com