Issue
I want to change a result ordered by local, but it appears that LC_COLLATE
cannot be changed.
Resolution
This is an example of changing en_US.UTF-8(default) to ja_JP.utf8:
You should be able to create the collation with
CREATE COLLATION ja_JP (locale = 'ja_JP.utf8');
Then:
ALTER TABLE foo ALTER COLUMN title TYPE VARCHAR COLLATE ja_JP;