Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to postgresql migration - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Oracle to postgresql migration
Date
Msg-id 78543062c8196b224f1a51ec46d45e34be7829ce.camel@cybertec.at
Whole thread Raw
In response to Oracle to postgresql migration  (Rama Krishnan <raghuldrag@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: sort order for UTF-8 char column with Japanese UTF-8
Next
From:
Date:
Subject: Using the indexing and sampling APIs to realize progressive features