Re: Wrong uppler lower for national characters.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Wrong uppler lower for national characters.
Date: 2003-10-14 18:17:16
Message-ID: Pine.LNX.4.44.0310142016080.22628-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Viacheslav N Tararin writes:

> select upper(field1) from table1;
>
> Convert all latin symbols <128 in to UPPER case but all not latin >128
> in lower case locale consistent. Function lower work vicevesa upper(),
> wrong too.
>
> ilake() function work wrong too.

"Right" and "wrong" are defined by your system locale. Check what locale
you have set in your PostgreSQL server and whether the system locale works
as you expect. If you have further problems please post more detail,
including the locale configuration and some actual data.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-10-14 18:42:53 Re: Bug in the information_schema.referential_constraints view
Previous Message Tom Lane 2003-10-14 17:50:10 Re: