MS SQL sorting a column with Chinese Name
<p>I have a database table which has English and Chinese name in them. I have changed the Chinese name column's collation to Chinese_PRC_CS_AS but it is still not sorting properly.</p>

<p>I would like them to sort according to how the dictionary using (pinyin). </p>

<p>May I know if anybody has done that before?</p>