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