Re: Patch for collation using ICU
От | Tatsuo Ishii |
---|---|
Тема | Re: Patch for collation using ICU |
Дата | |
Msg-id | 20050508.221925.78726559.t-ishii@sra.co.jp обсуждение исходный текст |
Ответ на | Re: Patch for collation using ICU ("John Hansen" <john@geeknet.com.au>) |
Ответы |
Re: Patch for collation using ICU
|
Список | pgsql-hackers |
> > > > On Sun, May 08, 2005 at 02:07:29PM +1000, John Hansen wrote: > > > > > Tatsuo Ishii wrote: > > > > > > > > > > So Japanese(including ASCII)/UNICODE behavior is > > > > perfectly correct > > > > > > at this moment. > > > > > > > > > > Right, so you _never_ use accented ascii characters in > > Japanese? > > > > > (like è for example, whose uppercase is È) > > > > > > > > That isn't ASCII. It's latin1 or some other ASCII extension. > > > > > > Point taken... > > > But... > > > > > > If you want EUC_JP (Japanese + ASCII) then use that as your > > backend encoding, not UTF-8 (unicode). > > > UTF-8 encoded databases are very useful for representing multiple > > > languages in the same database, but this usefulness > > vanishes if functions like upper/lower doesn't work correctly. > > > > I'm just curious if Germany/French/Spanish mixed text can be > > sorted correctly. I think these languages need their own > > locales even with UNICODE/ICU. > > No, they will not sort correctly, for that you still need the locale. I'm confused. I thought the ICU patches is intended for using on broken locale platforms? -- Tatsuo Ishii
В списке pgsql-hackers по дате отправления: