Hi Team,
We are migrating Oracle 11204 Database to PostgreSQL 9.6.6.
Oracle Character Set details
PARAMETER VALUE
---------------------------------------- --------------------
NLS_CHARACTERSE T WE8ISO8859P1
NLS_NCHAR_CHARA CTERSET AL16UTF16
NLS_SORT BINARY
Postgres Character Set details
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
postgres | dbauser | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
We observed that sorting (order by)is not working in Postgeres as like Oracle, in internet i have found that if i will change the database "Collate" and "Ctype" to "C" ,then it will work like Oracle, so My question is
If i will change the database "Collate" and "Ctype" to "C" , how it will affect other db operations (i.e. what are the negative impacts on database)?
Thanks
We are migrating Oracle 11204 Database to PostgreSQL 9.6.6.
Oracle Character Set details
PARAMETER VALUE
---------------------------------------- --------------------
NLS_CHARACTERSE T WE8ISO8859P1
NLS_NCHAR_CHARA CTERSET AL16UTF16
NLS_SORT BINARY
Postgres Character Set details
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+-----------------------
postgres | dbauser | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
We observed that sorting (order by)is not working in Postgeres as like Oracle, in internet i have found that if i will change the database "Collate" and "Ctype" to "C" ,then it will work like Oracle, so My question is
If i will change the database "Collate" and "Ctype" to "C" , how it will affect other db operations (i.e. what are the negative impacts on database)?
Thanks