Collation problem?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Collation problem?
Date: 2015-04-26 08:02:33
Message-ID: 20150426100233.5ec68ab5@pennywise2.havleik.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My databases looks like this...:

List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------+--------------+----------+-------------+-------------+-----------------------
dbname | owner | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
.......

And my problem is that I am using Norwegian in some tables and when using order by the sort order is not correct for the Norwegian letters..
So my guestion is if it is possible to get the correct sort order without recreating all my databases or initialize PGSQL?

Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2015-04-26 08:30:01 Re: Collation problem?
Previous Message swaxolez 2015-04-26 02:05:00 BDR Selective Replication