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

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

From
"yoursoft"
Date:
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.

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

From
Stephan Szabo
Date:
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.