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