Re: problems with lower() and unicode-databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter pilsl <pilsl(at)goldfisch(dot)at>
Cc: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: problems with lower() and unicode-databases
Date: 2004-09-30 14:48:51
Message-ID: 16521.1096555731@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

peter pilsl <pilsl(at)goldfisch(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message JEDIDIAH 2004-09-30 15:36:23 Re: [GENERAL] High Availability - Performace Scalability -
Previous Message Tom Lane 2004-09-30 14:35:21 Re: 7.3.4 vacuum/analyze error