Mikko escribió: > psql (PostgreSQL) 8.3.7 > > server_version 8.3.7 > server_encoding UTF8 > client_encoding win1252 > lc_numeric Finnish, Finland > lc_monetary Finnish, Finland > > testdb=# SELECT to_char(3.1415::numeric(5,2), '999D99L'); > > ERROR: invalid byte sequence for encoding "UTF8": 0x80 > HINT: This error can also happen if the byte sequence does not match > the encoding expected by the server, which is controlled by > "client_encoding".
FWIW 0x80 is the Euro symbol in Win1252 according to http://en.wikipedia.org/wiki/Windows-1252 Maybe the problem here is that the chosen locales are not UTF8. Does it work if you set lc_numeric and lc_monetary to "Finnish_Finland.65001" instead? Those should match the server_encoding. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
