DB Collate with Django ORM

collate_query.py

# Use ko_KR.utf8 for lower version of Postgres
# ex: select * from sample_table order by "name" COLLATE "ko-KR-x-icu";
ko_name = Func("name", function="ko-KR-x-icu", template='(%(expressions)s) COLLATE "%(function)s"')
queryset = queryset.order_by(ko_name.asc())

-- Manual control with SQL

-- Check current collates:
SELECT collname FROM pg_collation WHERE collname like '%KR%' ORDER BY collname;
SELECT datname, datdba, encoding, datcollate, datctype FROM pg_database;

-- Change DB collate:
UPDATE pg_database SET datcollate = 'ko_KR.utf8' WHERE datname = 'db_name';

-- Set collate in select query:
SELECT * FROM sample_table ORDER BY "name" COLLATE "ko-KR-x-icu";

-- ...or you can manually change collate below:
ALTER TABLE sample_table ALTER COLUMN name SET DATA TYPE text COLLATE "ko-KR-x-icu";

-- Rollback:
ALTER TABLE sample_table ALTER COLUMN name SET DATA TYPE text COLLATE "en_US";

-- Test it
SELECT * FROM sample_table ORDER BY "name" ASC;