Re: Multibyte (Japanese Character) Sorting

[Tatsuo Ishii <ishii(at)postgresql(dot)org>]

> 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