MongoDB uses unicode, instead of the coding for a certain local language, to sort data in this language (i.e. Chinese). Together with esProc, MongoDB can realize sorting in local language conveniently (i.e. sort Chinese according to Chinese phonetic alphabet). The following will teach you the method in detail by taking Chinese as an example.
person - a collection in MongoDB - stores names and genders as follows:
> db.person.find()
{ "_id" : ObjectId("544e4e070f03ad39eb2bf498"), "name" : "宿±", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf499"), "name" : "æéµ", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49a"), "name" : "å´ç¨", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49b"), "name" : "æç", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49c"), "name" : "å¬åè", "gender" : "ç·" }
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49d"), "name" : "鲿ºæ·±", "gender" : "ç·" }
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49e"), "name" : "æ¦æ¾", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf49f"), "name" : "é®å°äº", "gender" : "ç·" }
{ "_id" : ObjectId("544e4e070f03ad39eb2bf4a0"), "name" : "æ¨å¿", "gender" : "ç·"}
{ "_id" : ObjectId("544e4e070f03ad39eb2bf4a1"), "name" : "åäºå¨", "gender" : "女" }
{ "_id" : ObjectId("544e4e070f03ad39eb2bf4a2"), "name" : "æä¸å¨", "gender" : "女" }
{ "_id" : ObjectId("544e4e080f03ad39eb2bf4a3"), "name" : "çé", "gender" : "ç·"}
â¦
Sort the data using MongoDBâs sort function rather than the Chinese phonetic alphabet:
> db.person.find({},{"name":1,"gender":1,"_id":0}).sort({"name":1})
{ "name" : "å¬åè", "gender" : "ç·" }
{ "name" : "å´ç¨", "gender" : "ç·" }
{ "name" : "åäºå¨", "gender" : "女" }
{ "name" : "宿±", "gender" : "ç·" }
{ "name" : "æä¸å¨", "gender" : "女" }
{ "name" : "æç", "gender" : "ç·" }
{ "name" : "æéµ", "gender" : "ç·" }
{ "name" : "æ¨å¿", "gender" : "ç·" }
{ "name" : "æ¦æ¾", "gender" : "ç·" }
{ "name" : "çé", "gender" : "ç·" }
{ "name" : "é®å°äº", "gender" : "ç·" }
{ "name" : "鲿ºæ·±", "gender" : "ç·" }
â¦
The esProc script helping with MongoDB computation is as follows: