Maximilian Tyrtania wrote:
> am 08.05.2009 16:55 Uhr schrieb Rob Sargent unter robsargent@rocketmail.com:
> > and what locale are you running in?
>
> lc_collate | de_DE
> | Shows the collation order locale.
> lc_ctype | de_DE
> | Shows the character classification and case conversion locale.
>
> The encoding is UTF-8.
Note that the de_DE locale uses Latin9 encoding, which is incompatible
with UTF8. I'd try checking if the problem is reproducible in
de_DE.utf8 (you need to create a new database for testing, obviously).
If it's not, then the incompatible locale definition is causing the
problem.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support