-----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 - -- Gunnar "Nick" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bl...@pro-open.de _____________________________________________________________ In 1984 mainstream users were choosing VMS over UNIX. Ten years later they are choosing Windows over UNIX. What part of that message aren't you getting? - Tom Payne -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) iQEcBAEBAgAGBQJVPKJoAAoJEBAQrmsyiTOMhRsH/3RENBEhVBHCKpAURq9EdPdj gEB8vD9PY2U/m5L3vG/RrqNhtPbIhVsfLn0CUSqhTTh4VEmoiGIbRS8MTDxH79Nl Ic/ovsjioPy7feIPBKRKALTY4R+8KG/XAIuY2WEWUcy3NTr5NX3id+BcHnOc5nXU PB7QB3VD5a3YykWVE6/6OxskeoSiEN97ey4vbdav9qNNSQ60zt0gJa9SR7nGHsaV M8yF9fG57TeUFrTaEkZNkmZwC4Ui4w+eKFZk0m9L13JXaoZ4xIqLvH1nufKIO0uB SHBUl22MGKZoksg1KaAEvq6lYLGfdOvH53tsulw4nDR0w+VYztY4eIR0j1xm17c= =Sh2G -----END PGP SIGNATURE-----
0x3289338C.asc
Description: application/pgp-keys
0x3289338C.asc.sig
Description: Binary data
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
