Oracle to postgresql migration

Started by Rama Krishnanabout 4 years ago2 messagesgeneral

raghuldrag@gmail.com

about 4 years ago

Hi team,

How do we take care of database character set when trying to migrate from
oracle to postgres

In this example I am having in German

laurenz.albe@cybertec.at

about 4 years ago

In reply to: Rama Krishnan (#1)

Re: Oracle to postgresql migration

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.