Re: Collation problem?

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