From: | "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Collation problem? |
Date: | 2015-04-26 08:31:37 |
Message-ID: | 553CA269.1000404@pro-open.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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(dot)bluth(at)pro-open(dot)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-----
Attachment | Content-Type | Size |
---|---|---|
0x3289338C.asc | application/pgp-keys | 1.7 KB |
0x3289338C.asc.sig | application/octet-stream | 287 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bjørn T Johansen | 2015-04-26 08:59:10 | Re: Collation problem? |
Previous Message | Michael Paquier | 2015-04-26 08:30:01 | Re: Collation problem? |