| From: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | database collation "C" and "C.LATIN1" |
| Date: | 2023-03-09 08:22:37 |
| Message-ID: | PH0PR11MB51911905C6D8C753E98504FCD6B59@PH0PR11MB5191.namprd11.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
We create one database with collate= "C.LATIN1", any difference between "C" and "C.LATIN1" ? database encoding is "LATIN1".
oid | collname | collnamespace | collowner | collprovider | collisdeterministic | collencoding | collcollate | collctype | collv
ersion
-------+------------------------+---------------+-----------+--------------+---------------------+--------------+------------------+------------------+------
-------
950 | C | 11 | 10 | c | t | -1 | C | C |
12328 | C.latin1 | 11 | 10 | c | t | 8 | C.latin1 | C.latin1
Thanks,
James
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2023-03-09 08:29:43 | Re: database collation "C" and "C.LATIN1" |
| Previous Message | Tom Lane | 2023-03-08 18:42:46 | Re: PostgreSQL uses huge amount of memory |