Re: problems with lower() and unicode-databases - Mailing list pgsql-general

From Tom Lane
Subject Re: problems with lower() and unicode-databases
Date
Msg-id 16521.1096555731@sss.pgh.pa.us
Whole thread Raw
In response to problems with lower() and unicode-databases  (peter pilsl <pilsl@goldfisch.at>)
List pgsql-general
peter pilsl <pilsl@goldfisch.at> writes:
> postgres 7.4 on linux, glibc 2.2.4-6

> I've a table containing unicode-data and the lower()-function does not
> work proper. While it lowers standard letters like A->a,B->b ... it
> fails on special letters like german umlauts (� , � ...) that are simply
> keeped untouched.

upper() and lower() didn't support multibyte character sets before 8.0.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.3.4 vacuum/analyze error
Next
From: Miles Keaton
Date:
Subject: how to encode/encrypt a string