Home > mailing lists

Re: Oracle characterset and collation to Postgresql - Mailing list pgsql-admin

From	Laurenz Albe
Subject	Re: Oracle characterset and collation to Postgresql
Date	March 15, 2023 00:31:39
Msg-id	2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at Whole thread Raw
In response to	Oracle characterset and collation to Postgresql ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List	pgsql-admin

Tree view

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

pgsql-admin by date:

From: Thomas Kellerer
Date: 14 March 2023, 20:28:50
Subject: Re: CRUD tool?

From: Sbob
Date: 15 March 2023, 20:24:19
Subject: Automatic partition creation?

Re: Oracle characterset and collation to Postgresql - Mailing list pgsql-admin

Previous

Next