BUG #1813: lower() function doesn't work on unicode database
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.
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.