> Hi there, > > Im having a problem in sorting multibyte characters. > > I am using EUC-JP for my database encoding becuase we need to support > japanese (hiragana, katakana, kanji) text, since our clients are japanese. > > I have a table named "user_info" with the following fields: > > first_name character(60) NOT NULL > last_name character(60) NOT NULL > > We've forced doublebyte character our entries so that all data stored in > the table are doublebyte. The problem is, the sorting procedure. when > you user ORDER BY last_name ASC, the list is not sorted properly. Please > help me fix this problem. Thank you in advanced. I'm not sure why you think "not sorted properly", but my wild guess is your OS's locale data is broken. Use C locale. -- Tatsuo Ishii SRA OSS, Inc. Japan
