Re: BUG #1813: lower() function doesn't work on unicode

On Sat, 6 Aug 2005, yoursoft wrote:

> The following bug has been logged online:
>
> Bug reference: 1813
> Logged by: yoursoft
> Email address: yoursoft(at)freemail(dot)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(at)freemail(dot)hu(dot)

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.