Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between C and en_US.UTF-8 Collate & CType inPostgres 10.x - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Difference between C and en_US.UTF-8 Collate & CType inPostgres 10.x
Date
Msg-id 0f5ad1359ca05bb3e77c346aa012b1df1d8f5429.camel@cybertec.at
Whole thread Raw
In response to Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x  (Debraj Manna <subharaj.manna@gmail.com>)
Responses Re: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x
List pgsql-admin
Tree view 
Debraj Manna wrote:
> Can someone let me know what is the difference we are expected to observe if we set
> Collate & Ctype to C as against  en_US.UTF-8 with encoding set to UTF8 in both the cases ?

For one, the ordering will be substantially different.

Compare the result of these two queries:

SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE "C";
SELECT chr(i) FROM generate_series(1, 50000) i ORDER BY chr(i) COLLATE "en_US.utf8";

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: 范国腾
Date:
Subject: how to debug the postgres performance issue
Next
From: Amine Tengilimoglu
Date:
Subject: postgresql HA solution for different network domain