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 |