By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Database collation and Character Set

P: 1
Hi Team,

We are migrating Oracle 11204 Database to PostgreSQL 9.6.6.
Oracle Character Set details

PARAMETER VALUE
---------------------------------------- --------------------
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET 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
Mar 26 '18 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.