Both follow "C" collate behavior ,right? -----Original Message----- From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx> Sent: Thursday, March 9, 2023 4:30 PM To: James Pang (chaolpan) <chaolpan@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: Re: database collation "C" and "C.LATIN1" On Thu, 2023-03-09 at 08:22 +0000, James Pang (chaolpan) wrote: > We create one database with collate= “C.LATIN1”, any difference between “C” and “C.LATIN1” ? > database encoding is “LATIN1”. > > oid | collname | collencoding | collcollate | > collctype | collversion > -------+------------------------+--------------+------------------+------------------+------------- > 950 | C | -1 | C | C | > 12328 | C.latin1 | 8 | C.latin1 | C.latin1 | The difference is a technicality: "C" is encoding agnostic (-1) and can be used with any encoding, while "C.latin1" can only be used with encoding LATIN1 (8). The behavior is the same. Yours, Laurenz Albe
