Florian Wunderlich wrote: > - input file in encoding iso-8859-1: > > set client_encoding='iso-8859-1'; > select upper('ä'), lower('Ä'); > > (note: the argument to upper is a lower case a umlaut, while the argument to > lower is an upper case a umlaut) > > - database "iso" with encoding iso-8859-1, > database "utf" with encoding utf-8, > both in a cluster with locale=de_DE
I think this is just a case of a misconfigured server. If you choose locale de_DE, which supports only the iso-8859-1 encoding, it is an error to build a database with utf8 encoding -- which is why 8.3 rejects that combination. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate