charset을 euc_ksc로 수정해 보세요.

다음은 테스트한 결과입니다.

(ASE 12.5)

1> select * from rich
2> order by b
3> go
 a           b                   
 ----------- --------------------
        2333 한한한김            
        1333 한한한박            
         333 한한한오            
        5333 한한한윤            
        4333 한한한이            
        6333 한한한장            
        7333 한한한최            
        3333 한한한한            
        8333 한한한홍            
        9333 한한한황            

(10 rows affected)

sp_helpsort를 하시면, Char_set을 확인할 수 있습니다.

1> sp_helpsort
2> go
 
 Collation Name                 Collation ID
 ------------------------------ ------------
 defaultml                                20
 thaidict                                 21
 iso14651                                 22
 utf8bin                                  24
 binary                                   25
 altnoacc                                 39
 altdict                                  45
 altnocsp                                 46
 scandict                                 47
 scannocp                                 48
 dict                                     51
 nocase                                   52
 nocasep                                  53
 noaccent                                 54
 espdict                                  55
 espnocs                                  56
 espnoac                                  57
 rusnocs                                  59
 cyrnocs                                  64
 elldict                                  65
 hundict                                  69
 hunnoac                                  70
 hunnocs                                  71
 turknoac                                 73
 turknocs                                 74
 
 Loadable Sort Table Name       Collation ID
 ------------------------------ ------------
 cp932bin                                129
 dynix                                   130
 gb2312bn                                137
 cyrdict                                 140
 turdict                                 155
 euckscbn                                161
 gbpinyin                                163
 rusdict                                 165
 sjisbin                                 179
 eucjisbn                                192
 big5bin                                 194
 
Sort Order Description
                                                                   
 ------------------------------------------------------------------
 Character Set = 150, eucksc                                       
     Extended Unix Code for KSC-5601.                              
     Class 2 Character Set                                         
 Sort Order = 50, bin_eucksc                                       
     Binary sort order for Korean using the EUC KSC character set (
     eucksc).                                                      
(return status = 0)
1>

존넘님 감사합니다!!!