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

Re: trouble with to_char('L')

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Kedar PotdarDate: 2009-04-21 14:03:10
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax
Previous:From: Alvaro HerreraDate: 2009-04-21 13:58:11
Subject: Re: 8.4 semi-join slows down query performance (EXISTS)

pgsql-general by date

Next:From: rayDate: 2009-04-21 14:25:11
Subject: Re: Re-Install data folder failure
Previous:From: Diego SchulzDate: 2009-04-21 13:26:42
Subject: Re: Error stranger

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