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

In response to

• trouble with to_char('L') at 2009-04-20 21:00:07 from Mikko

Responses

• Re: trouble with to_char('L') at 2009-04-21 13:58:21 from Mikko

pgsql-hackers by date

Next:	From: Abhijit Menon-Sen	Date: 2009-04-21 10:46:04
	Subject: Re: [PATCH] Add a test for pg_get_functiondef()
Previous:	From: vacuum	Date: 2009-04-21 09:38:06
	Subject: 8.4 semi-join slows down query performance (EXISTS)

pgsql-general by date

Next:	From: Geoff Caplan	Date: 2009-04-21 11:02:02
	Subject: This is my first template
Previous:	From: John DeSoi	Date: 2009-04-21 02:13:53
	Subject: Re: converting from bytea to integers