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: (view raw, whole thread or download thread mbox)
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

If connected to postgres database the query returns 3,14.


In response to


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-2017 The PostgreSQL Global Development Group