Re: Oracle characterset and collation to Postgresql

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Oracle characterset and collation to Postgresql
Date: 2023-03-14 21:31:39
Message-ID: 2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2023-03-15 17:24:19 Automatic partition creation?
Previous Message Thomas Kellerer 2023-03-14 17:28:50 Re: CRUD tool?