汉字排序 比如“一二三四五..."

在sqlserver中排序是”二六七三四五一“，怎么样可以排成”一二三四五六七“，
是否用到自定义排序，怎么用？
---------------------------------------------------------------
select * from activity
order by
case when activityname= '一' then '1'
when activityname= '二' then '2'
when activityname= '三' then '3'
when activityname= '四' then '4'
when activityname= '五' then '5'
when activityname= '六' then '6'
when activityname= '七' then '7'
end