This is a solution for sorting Chinese in Pinyin. If you are using PostgreSQL and looking for a way to sorting records in Pinyin, this is the extension you would like to see.

This extension just map Chinese into Pinyin. Then PostgreSQL could sort. In this extension, there are other help functions like is_chinese() etc.

Enjoy.

-- PostgreSQL拼音排序