Re: Bug #659: lower()/upper() bug on ->multibyte<- DB
| От | Enke, Michael |
|---|---|
| Тема | Re: Bug #659: lower()/upper() bug on ->multibyte<- DB |
| Дата | |
| Msg-id | 3CDBA0A1.DB89C634@wincor-nixdorf.com обсуждение исходный текст |
| Ответ на | Re: Bug #659: lower()/upper() bug on ->multibyte<- DB (Tatsuo Ishii <t-ishii@sra.co.jp>) |
| Ответы |
Re: Bug #659: lower()/upper() bug on ->multibyte<- DB
|
| Список | pgsql-bugs |
Tatsuo Ishii wrote:
> I don't think using de_DE.utf8 helps. The locale support just calls
> tolower(), which is not be able to handle multibyte chars.
>
> > > Oops. That should be:
> > >
> > > select convert(lower(convert('X', 'LATIN1')),'LATIN1','UNICODE');
> > > It looks ugly, but works.
> >
> > Sorry, it doesn't work. The same here, I get back the case I put in at X, not the lower case.
>
> Are you sure to use de_DE locale (not de_DE.utf8)?
> Included are sample scripts being work with me using de_DE locale.
Ok, this is working now (I cann't reproduce why not at the first time).
Is it planned to implement it so that I can write lower()/ upper() for multibyte
according to SQL standard (without convert)?
I could do it if you tell me where the final tolower()/toupper() happens.
(but not before middle of June).
Regards,
Michael
В списке pgsql-bugs по дате отправления: