Skip site navigation (1) Skip section navigation (2)

trouble with to_char('L')

From: Mikko <mhannesy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: trouble with to_char('L')
Date: 2009-04-20 21:00:07
Message-ID: 40c6d9160904201400n79f19a05w64455ba59428a920@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: KaiGai KoheiDate: 2009-04-20 23:56:12
Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE
Previous:From: Tobias ZahnDate: 2009-04-20 19:59:25
Subject: GEQO: ERX

pgsql-general by date

Next:From: Robert MortonDate: 2009-04-20 21:21:31
Subject: round behavior differs between 8.1.5 and 8.3.7
Previous:From: Matthew PugsleyDate: 2009-04-20 20:34:25
Subject: update one table with another

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group