On Sun, 26 Apr 2015 10:59:10 +0200 Bjørn T Johansen <btj@xxxxxxxxxx> wrote: > On Sun, 26 Apr 2015 10:31:37 +0200 > "Gunnar \"Nick\" Bluth" <gunnar.bluth@xxxxxxxxxxx> 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 > > Ok, tried to run: alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8 But I just get: [Error Code: 0, SQL State: 42601] ERROR: syntax error at or near "varchar" (tried without the varchar also..) Also tried running: select fornavn from medlem order by fornavn collate nb_NO Then I get: ERROR: collation "nb_no" for encoding "UTF8" does not exist Do I need to add some collation to the database or? BTJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
