Postgres Pro
Downloads
Home   >   mailing lists

Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x - Mailing list pgsql-admin

From Debraj Manna
Subject Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x
Date
Msg-id CAF6DVKNU0vb4ZeQQ-=agg69QJU3wdjPnMYYrPYY7CKc6iOU7eQ@mail.gmail.com
Whole thread Raw
Responses Re: Difference between C and en_US.UTF-8 Collate & CType inPostgres 10.x  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view

Hi


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 ?


  Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges

-----------+----------+----------+---------+-------+-----------------------

postgres  | postgres | UTF8     | C       | C     |


 Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges

-----------+----------+----------+-------------+-------------+-----------------------

postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

pgsql-admin by date:

Previous
From: Peter Tormey
Date:
Subject: Re: postgresql and glusterFS
Next
From: 范国腾
Date:
Subject: how to debug the postgres performance issue