Re: trouble with to_char('L')

Mikko <mhannesy@gmail.com>

From: Mikko <mhannesy@gmail.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-general@postgresql.org
Date: 2009-04-21T13:58:21Z
Lists: pgsql-hackers, pgsql-general
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".

If connected to postgres database the query returns 3,14.

Mikko