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

#1

On Sat, 6 Aug 2005, yoursoft wrote:

Quote:

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.

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1813: lower() function doesn't work on unicode - 08-08-2005 , 12:31 AM