Why does postgresql issue the error message "ERROR: Could not convert UTF-8 to ISO8859-1", when I execute a select statement after I changed the client encoding to latin1 ???
Because every UTF8 character cannot necessarily be encoded as Latin1. Unicode has more than 64,0000 characters, Latin1 has less than 256.
Check your database for non-Latin1 characaters.
If I set the client encoding to utf8 by entering "\encoding utf8", then the same select will print all the columns bu display
ÃŒ for ü ö for ö
and mess up other "special characters".
This is because your display (xterm, whatever) is set to Latin1, presumably. There are at least three different encoding settings here: how your data is stored in the database, what the server sends to psql, and what your display thinks its getting. These must all be consistent with one another.
- John D. Burger MITRE
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
