Re: [GENERAL] Multibyte (Japanese Character) Sorting

2008-04-30 Thread Tatsuo Ishii
I have taken a look at the screen shot. Yes, the sort order seems pretty ridiculous. I tested similar data on my Linux box and the result was nothing strange. Do you have an index on the field? What is the platform PostgreSQL is running on? Do you see the same problem using psql? Can you give me th

Re: [GENERAL] Multibyte (Japanese Character) Sorting

2008-04-29 Thread Tatsuo Ishii
> 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_

[GENERAL] Multibyte (Japanese Character) Sorting

2008-04-29 Thread Mhor Gonzales
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)