| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Morton | 2009-04-20 21:21:31 | round behavior differs between 8.1.5 and 8.3.7 |
| Previous Message | Matthew Pugsley | 2009-04-20 20:34:25 | update one table with another |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2009-04-20 23:56:12 | Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE |
| Previous Message | Tobias Zahn | 2009-04-20 19:59:25 | GEQO: ERX |