Postgres Pro
Downloads
Home   >   mailing lists

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

From yoursoft
Subject BUG #1813: lower() function doesn't work on unicode database
Date
Msg-id 20050806102503.8A608F0B14@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1813: lower() function doesn't work on unicode  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: "Michael Afanasiev"
Date:
Subject: BUG #1808: bug: plan bugs on alert /drop table
Next
From: "willie"
Date:
Subject: BUG #1810: Select * From XXX where xfield = 'Chinese_String';