Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE
Date
Msg-id 7835.1180379707@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE  ("Florian Wunderlich" <fwunderlich@factor3.de>)
Responses Re: BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE  (Florian Wunderlich <fwunderlich@factor3.de>)
List pgsql-bugs
Tree view 
"Florian Wunderlich" <fwunderlich@factor3.de> writes:
> The following commands are
> used in a file encoded in iso-8859-1:

> set client_encoding='utf-8';
> select upper('äöü');

Isn't that pilot error, plain and simple?  You told the machine your
input is in utf8, not latin1.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Greg Quinn"
Date:
Subject: Vista always prompts for password on createdb.exe
Next
From: Florian Wunderlich
Date:
Subject: Re: BUG #3316: upper() does not convert to upper case on database with encoding utf-8 and locale de_DE