Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Changing collate & ctype for an existing database - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Changing collate & ctype for an existing database
Date
Msg-id 24150.1499887556@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Changing collate & ctype for an existing database  (rihad <rihad@mail.ru>)
Responses Re: [GENERAL] Changing collate & ctype for an existing database  (rihad <rihad@mail.ru>)
Re: [GENERAL] Changing collate & ctype for an existing database  (rihad <rihad@mail.ru>)
List pgsql-general
Tree view 
rihad <rihad@mail.ru> writes:
> What if only English letters are used in the textual indices (ascii
> 0-127), would they still be impacted after datctype&datcollate
> "C"->"en_US.UTF-8" change?

Yes, as even minimal testing would have told you.  C sort order is
more case-sensitive, for instance.

            regards, tom lane

pgsql-general by date:

Previous
From: "Zhu, Joshua"
Date:
Subject: Re: [GENERAL] BDR node removal and rejoin
Next
From: Jeff Janes
Date:
Subject: [GENERAL] Monitoring of a hot standby with a largely idle master