På mandag 13. november 2017 kl. 21:40:47, skrev Peter Geoghegan <p...@bowt.ie <mailto:p...@bowt.ie>>: On Mon, Nov 13, 2017 at 11:48 AM, Andreas Joseph Krogh <andr...@visena.com> wrote: > Ok, so I have to explicitly specify like this: > > create table test(id serial primary key, name varchar collate "nb_NO" not null);
That doesn't look like an ICU locale. You may mean "nb-NO-x-icu". But otherwise, yes. Ok, is there a way I can get a list of ICU-collations? > Will ICU be used here as long as PG is compiled with ICU-suppoert, as the debian-packages are, or do I have to specify collation-provider? If you did initdb with a version with ICU support, the ICU collations should be there. > Do I have to explicitly specify collation when using ORDER by on that column for index and abbreviated keys to be used? Only if you didn't define the column with a per-column collation initially. Ok, thanks. Looking forward to this being a per-database setting so it's (hopefully) more transparent. -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
