Re: Multibyte (Japanese Character) Sorting

> 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