Re: BUG #6214: can't change Column COLLATE - Mailing list pgsql-bugs

小豕 <e9320.tw@gmail.com> writes:
> Use   ALTER TABLE item  ALTER COLUMN title TYPE character varying(2000)
> COLLATE pg_catalog."zh_TW.euctw";
> but, SQL state: 42704  "UTF8" "pg_catalog.zh_TW.euctw" not found

I hope that's not the exact phrasing of the error message ... but
what it's probably trying to tell you is that you can't use an EUC_TW
based locale in a database with UTF8 encoding.  Try zh_TW.utf8.
        regards, tom lane