Postgres Pro
Downloads
Home   >   mailing lists

BUG #3786: report error:"ERROR: invalid byte sequence for encoding "UTF8"" - Mailing list pgsql-bugs

From wengxc
Subject BUG #3786: report error:"ERROR: invalid byte sequence for encoding "UTF8""
Date
Msg-id 200711280543.lAS5hY9j006661@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3786
Logged by:          wengxc
Email address:      wengxc@zjheadway.com
PostgreSQL version: 8.2.5
Operating system:   RHEL AS4
Description:        report error:"ERROR:  invalid byte sequence for encoding
"UTF8""
Details:

my postgresql server encoding:UTF-8,client_encoding:gbk
when I execute some query sql,the database report the error frequently
:“ERROR:  invalid byte sequence for encoding "UTF8":
0xe334”，especially when insert some text include "\" and
numbers,e.g.\888.
there is no error report when insert the text, but it occur when select ,how
can I resolve this problem If I don't change the server encoding and client
encoding?
thanks

pgsql-bugs by date:

Previous
From: "Stephen Bespalko"
Date:
Subject: BUG #3784: pg_ctl fails to start server when called with -c parameters
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #3782: table_to_xmlschema and xsd:simpleType