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
2011/9/19 Tom Lane <t...@sss.pgh.pa.us> > "yulin liu" <e9320...@gmail.com> writes: > > can't change Column COLLATE pg_catalog."default" to > pg_catalog."zh_TW.euctw" > > Use ALTER TABLE ... ALTER COLUMN ... TYPE ... COLLATE ... > > regards, tom lane >
