On Tue, 2023-03-14 at 07:25 +0000, James Pang (chaolpan) wrote: > Hi, > We plan to migrate from Oracle to Postgresql 14. Oracle AL32UTF8 , collate BINARY, > migrate to Postgresql , database encoding UTF8, collate is “C” or “C.UTF8” ? > Any key difference between collate C and C.UTF8 ? Use "C". See this almost identical thread: https://www.postgresql.org/message-id/flat/PH0PR11MB51911905C6D8C753E98504FCD6B59%40PH0PR11MB5191.namprd11.prod.outlook.com Yours, Laurenz Albe
