Re: Collation problem?

On Sun, 26 Apr 2015 12:43:57 +0200
Oliver Elphick <olly(at)lfix(dot)co(dot)uk> wrote:

> On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote:
> >
> > CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8)
> >
> > But then I get this:
> >
> > ERROR: could not create locale "nb_no.utf8": No such file or
> > directory
> > DETAIL: The operating system could not find any locale data for the
> > locale name "nb_no.utf8".
> >
> > I am using Fedora 21 and running locale -a shows these among the
> > locales:
> >
> > nb_NO
> > nb_NO.iso88591
> > nb_NO.utf8
> >
> > What am I missing? I see the error message from pgsql shows the
> > country code using lowercase, is that the problem?
> > Any ideas?
>
> Perhaps you need to use double quotes to preserve case:
> LOCALE = "nb_NO.utf8"
>

Yes, that's it... :) Tried using double qoutes around both nb_NO and nb_NO.utf8 but that did not work but only around nb_NO.utf8 did the trick...

Thx... :)

BTJ