How to choose correct collation to create database when migrating Postgres from Windows to Linux using pg_dump?

Question

I have below configuration in my source window database

Name	Owner	Encoding	Collate	Ctype	Access privileges
sourcedb	appuser	UTF8	English_South Africa.1252	English_South Africa.1252

I want to know how to check what is the equivalent collation when I migrate to Linux. I feel en_ZA.UTF-8 as the equivalent. Need guidance if this is correct.

Laurenz Albe · Accepted Answer · 2021-11-20 05:57:57Z

0

Yes, en_ZA.UTF-8 would be the proper locale.

Make sure it is defined on your system using locale -a. If it doesn't show up, you have to configure it in a way that depends on your Linux distribution.

answered Nov 20, 2021 at 5:57

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to choose correct collation to create database when migrating Postgres from Windows to Linux using pg_dump?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related