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 по дате отправления: