The following bug has been logged online:
Bug reference: 3316
Logged by: Florian Wunderlich
Email address: fwunderlich(at)factor3(dot)de
PostgreSQL version: 8.2.4
Operating system: Linux 220.127.116.11 (debian)
Description: upper() does not convert to upper case on database with
encoding utf-8 and locale de_DE
The database cluster has been initialized with locale=de_DE.
SHOW ALL shows all lc_ variables as "de_DE".
There are two databases: temp which has been created with encoding='utf-8',
and temp2 with encoding='iso-8859-1'.
Both databases are completely empty.
The console is running with encoding iso-8859-1. The following commands are
used in a file encoded in iso-8859-1:
In case the argument to upper() does not come out as expected: it is an
a-umlaut, o-umlaut and u-umlaut.
The following command is then used:
iconv -f iso-8859-1 -t utf-8 | psql temp | iconv -f utf-8 -t iso-8859-1
This converts the iso-8859-1 encoded file from above to utf-8 and converts
the psql output back to iso-8859-1.
For database temp, this yields "" (lower case letters), while for
temp2, it yields "" (upper case letters), which is correct.
I did not find a bug report for this problem on pgsql-bugs or with Google.
It seems that there have been problems in the past with multibyte database,
but for 8.1, they have been fixed and using a multibyte database should work
pgsql-bugs by date
|Next:||From: Greg Quinn||Date: 2007-05-28 18:43:18|
|Subject: Vista always prompts for password on createdb.exe|
|Previous:||From: Douglas Toltzman||Date: 2007-05-28 15:56:38|
|Subject: Re: BUG #3315: Cannot configure XP over Static IP|