Search Postgresql Archives

Re: ERROR: Could not convert UTF-8 to ISO8859-1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux