| From: | Mikko <mhannesy(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: trouble with to_char('L') |
| Date: | 2009-04-21 13:58:21 |
| Message-ID: | 40c6d9160904210658y590377cfw6dbbecb53d2b8be0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
psql (PostgreSQL) 8.3.7
server_version 8.3.7
server_encoding UTF8
client_encoding win1252
lc_numeric Finnish, Finland
lc_monetary Finnish, Finland
testdb=# SELECT to_char(3.1415::numeric(5,2), '999D99L');
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".
If connected to postgres database the query returns 3,14.
Mikko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ray | 2009-04-21 14:25:11 | Re: Re-Install data folder failure |
| Previous Message | Diego Schulz | 2009-04-21 13:26:42 | Re: Error stranger |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kedar Potdar | 2009-04-21 14:03:10 | Re: Automating Partitions in PostgreSQL - Query on syntax |
| Previous Message | Alvaro Herrera | 2009-04-21 13:58:11 | Re: 8.4 semi-join slows down query performance (EXISTS) |