Re: Oracle to postgresql migration

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rama Krishnan <raghuldrag(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to postgresql migration
Date: 2022-02-03 15:10:59
Message-ID: 78543062c8196b224f1a51ec46d45e34be7829ce.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2022-02-03 at 20:24 +0530, Rama Krishnan wrote:
> How do we take care of database character set when trying
> to migrate from oracle to postgres

If NLS_SORT and NLS_COMP are set to German in Oracle,
just create the PostgreSQL to a German collation to get
a similar behavior.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hohenstein 2022-02-03 15:24:54 Using the indexing and sampling APIs to realize progressive features
Previous Message Tom Lane 2022-02-03 15:00:37 Re: sort order for UTF-8 char column with Japanese UTF-8