Search Postgresql Archives

Re: Collation problem?

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

 



On Sun, 26 Apr 2015 11:48:37 +0200
Oliver Elphick <olly@xxxxxxxxxx> wrote:

> On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote:
> > Ok, tried to run:
> > 
> > alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8
> > 
> > But I just get:
> > 
> >  [Error Code: 0, SQL State: 42601]  ERROR: syntax error at or near "varchar"
> > (tried without the varchar also..)
> 
> ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE
> collation ] [ USING expression ]
> 
> 
> You need to add the TYPE key word, I think.
> 
> Oliver Elphick
> 
> 
> 

Tried that to but got the same error..

But I think I need to create the collation in the database, but I am trying to run the following statement:

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?


BTJ


-- 
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