Database collation and Character Set

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chanakya02
    New Member
    • Mar 2018
    • 1

    Database collation and Character Set

    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
Working...