Re: Collation problem?

On Sun, 26 Apr 2015 10:31:37 +0200
"Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
> > 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?
> >
> Sure (i.e., if you're on a half recent version):
>
> ALTER TABLE <yourtable> ALTER COLUMN <yourcolumn> COLLATE <collation>
>
>
> http://www.postgresql.org/docs/9.4/static/sql-altertable.html
>

Yes, I am using 9.4.x so I will check this out... Thx... :)

BTJ