Search Postgresql Archives

Re: Collation problem?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux