Re: BUG #1813: lower() function doesn't work on unicode - Mailing list pgsql-bugs

On Sat, 6 Aug 2005, yoursoft wrote:

> The following bug has been logged online:
>
> Bug reference:      1813
> Logged by:          yoursoft
> Email address:      yoursoft@freemail.hu
> PostgreSQL version: 8.0.3
> Operating system:   SuSE 9.3 professional
> Description:        lower() function doesn't  work on unicode database
> Details:
>
> We have a filesystem with latin2. The database created in unicode.
> When we insert some Hungarian chars into it, and make a 'select kifejezes
> from table' the result is fine.
> When make 'select lower(kifejezes) from table', the result is wrong.
> If any questions with the bug, please mail to yoursoft@freemail.hu.

What was the locale set to for the call to initdb (try "SHOW LC_CTYPE;")?

The first things to check are that the locale is for Hungarian and that it
is a UTF8 locale if the database is unicode.