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

From: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Difference between C and en_US.UTF-8 Collate & CType in Postgres 10.x
Date: 2018-09-14 08:46:26
Message-ID: CAF6DVKNU0vb4ZeQQ-=agg69QJU3wdjPnMYYrPYY7CKc6iOU7eQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 |

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message 范国腾 2018-09-14 09:34:20 how to debug the postgres performance issue
Previous Message Peter Tormey 2018-09-13 13:07:10 Re: postgresql and glusterFS