Mikko wrote: > 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'. That is strange. What is your psql version? What is the output of the following commands: SHOW server_version; SHOW server_encoding; SHOW client_encoding; SHOW lc_numeric; SHOW lc_monetary; SELECT to_char(3.1415::numeric(5,2), '999D99L'); Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
