BUG #4579: to_char & utf8

From: "Anton" <pyo(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4579: to_char & utf8
Date: 2008-12-14 20:18:42
Message-ID: 200812142018.mBEKIg27058291@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4579
Logged by: Anton
Email address: pyo(at)mail(dot)ru
PostgreSQL version: 8.2 & 8.3
Operating system: Windows XP
Description: to_char & utf8
Details:

Hi!

I have DB with UTF8 character set. When I connect to it any client with
client_encoding WIN-1251 and try execute query like:
select to_char(field, 'FM999G999G999G999') from table;
I get an error:
invalid byte sequence for encoding "UTF8": 0xa0
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".

Thanks.

Browse pgsql-bugs by date

  From Date Subject
Next Message Sameer Mahajan 2008-12-15 11:45:19 Re: BUG #4568: sporadic error doing COUNT(*) on empty table
Previous Message Dave Page 2008-12-14 19:53:44 Re: BUG #4568: sporadic error doing COUNT(*) on empty table