Skip site navigation (1) Skip section navigation (2)

Re: Bug #659: lower()/upper() bug on ->multibyte<- DB

From: "Enke, Michael" <michael(dot)enke(at)wincor-nixdorf(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #659: lower()/upper() bug on ->multibyte<- DB
Date: 2002-05-10 10:27:45
Message-ID: 3CDBA0A1.DB89C634@wincor-nixdorf.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Jan WieckDate: 2002-05-10 10:29:15
Subject: Re: Queries using rules show no rows modified?
Previous:From: Jan WieckDate: 2002-05-10 10:19:16
Subject: Re: Queries using rules show no rows modified?

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-05-10 15:47:19
Subject: Re: Bug #663: ERROR: SearchSysCache: Bad cache id 27
Previous:From: pgsql-bugsDate: 2002-05-10 04:12:46
Subject: Bug #663: ERROR: SearchSysCache: Bad cache id 27

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group