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 <[email protected]> > "yulin liu" <[email protected]> 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 >
