Обсуждение: Oracle characterset and collation to Postgresql

Поиск
Список
Период
Сортировка

Oracle characterset and collation to Postgresql

От
"James Pang (chaolpan)"
Дата:

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 ?  

 

Thank,

 

James

Re: Oracle characterset and collation to Postgresql

От
Laurenz Albe
Дата:
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