Skip site navigation (1) Skip section navigation (2)

BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE

From: "Florian Wunderlich" <fwunderlich(at)factor3(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE
Date: 2007-05-28 16:59:51
Message-ID: 200705281659.l4SGxpLa019529@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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 2.6.15.6 (debian)
Description:        upper() does not convert to upper case on database with
encoding utf-8 and locale de_DE
Details: 

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:

set client_encoding='utf-8';
select upper('');

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
fine.

Responses

pgsql-bugs by date

Next:From: Greg QuinnDate: 2007-05-28 18:43:18
Subject: Vista always prompts for password on createdb.exe
Previous:From: Douglas ToltzmanDate: 2007-05-28 15:56:38
Subject: Re: BUG #3315: Cannot configure XP over Static IP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group