On Wed, 2022-01-12 at 13:31 +0000, James Pang (chaolpan) wrote: > We plan to migrate from Oracle to Postgresql 13, existing Oracle database charaterset WE8ISO8859P1 , > NLS_SORT = BINARY, NLS_COM=BINARY. we want to keep same encoding and collation in Postgresql 13 as Oracle, > so encoding=LATIN1 (Aliases ISO88591), what’s the suggested collation and ctype? Using ‘C’,’POSIX’, or en_US.LATIN1 ? > if using en_US.LATIN1 any impact to indexes and query where like % ? > The OS is Redhat 8, when export NLS_LANG=en_US.LATIN1, LC_COLLATE and LC_CTYPE automatically set to en_US.LATIN1, > and then initdb create database clusters with collname, collation, ctype all = en_US.LATIN1. I advise against using any encoding other than UTF-8. What are you worried about? For the locale, you can get the same behavior as in Oracle by using "C" or "POSIX" (they are the same). Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
