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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-10 15:47:19 | Re: Bug #663: ERROR: SearchSysCache: Bad cache id 27 |
Previous Message | pgsql-bugs | 2002-05-10 04:12:46 | Bug #663: ERROR: SearchSysCache: Bad cache id 27 |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-05-10 10:29:15 | Re: Queries using rules show no rows modified? |
Previous Message | Jan Wieck | 2002-05-10 10:19:16 | Re: Queries using rules show no rows modified? |