trouble with to_char('L')
Mikko <mhannesy@gmail.com>
From: Mikko <mhannesy@gmail.com>
To: pgsql-general@postgresql.org
Date: 2009-04-20T21:00:07Z
Lists: pgsql-hackers, pgsql-general
Hi, my database has UTF8 encoding and Finnish locale, the client_encoding and the console is set to WIN1252. I created a table with a single NUMERIC(5,2) column and inserted a few values. Running a query 'SELECT to_char(money, '999D99L') FROM table' through psql gives the following error message: 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". The graphical Query tool returns a set of empty rows. The query works ok without the 'L'. Thanks in advance, Mikko