KB45350: Freeform SQL report cannot correctly sort on Chinese character in MicroStrategy Developer and Web 9.x

SYMPTOM:
 
Freeform SQL report cannot correctly sort on Chinese character in Strategy Developer and Web 9.x as shown below:
 

 
The desired report which sorts on DESC form of attribute Category3 in ascending order is as shown below:
 

 
CAUSE:
 
One possible cause for this issue is that the column the sorting order is based on are mapping to attribute form of managed object. In such kind of scenario, "Support multiple languages" option for this form is grayed out as shown below:
 
 

 
ACTION:
 
 

1. Create a new project attribute with  "Support multiple languages" option checked in the DESC form by following tech note below:

KB44891: Report grid cannot correctly sort on Chinese characters in pinyin order in MicroStrategy Desktop 9.x  
 
 
 

• Modify Freeform SQL definition and map columns to this project attribute instead of managed object attribute.