pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: James Pang (chaolpan) <chaolpan@cisco.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Oracle characterset and collation to Postgresql
Date: Tue, 14 Mar 2023 22:31:39 +0100
Message-ID: <2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at> (raw)
In-Reply-To: <PH0PR11MB51913174B9222AE60F9AEA44D6BE9@PH0PR11MB5191.namprd11.prod.outlook.com>
References: <PH0PR11MB51913174B9222AE60F9AEA44D6BE9@PH0PR11MB5191.namprd11.prod.outlook.com>

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.na...

Yours,
Laurenz Albe





view thread (2+ messages)

Message-ID: <2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at>
Permalink:  ../2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at/
Also on:    postgresql.org/message-id/2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, chaolpan@cisco.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Oracle characterset and collation to Postgresql
  In-Reply-To: <2eac4511bf140cbbf926cf84010f4f2c8ce0c62c.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox