Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5C851FD81BD for ; Thu, 29 Mar 2012 00:00:52 -0300 (ADT) Received: from mail-yx0-f174.google.com ([209.85.213.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SD5bX-0002Dj-5y for pgsql-admin@postgresql.org; Thu, 29 Mar 2012 03:00:51 +0000 Received: by yenl12 with SMTP id l12so1211049yen.19 for ; Wed, 28 Mar 2012 20:00:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=date:from:to:reply-to:subject:x-priority:x-guid:x-has-attach :x-mailer:mime-version:message-id:content-type; bh=GYFShFihvaUfzN9Ibt6Q3wOXT7cniXUXZxkj2nLMPZI=; b=E44VjTVly1IM3zEKP769/wi0WLABnR3jM6Vc+0SYWTYFPkrXLdPKVRYMp7a7UVABcS ogu6t8T+uwdBygXmuq967xwBBHJK9w5Yl5QbkhGWjYSXSg8vWtC9ePnYY5qZ+6nWUz4b 5mEd1pFEpH76eXaFlGeNl0UbsYitJ0ta+FVaW0KXZr22fHOgcfy+cPYhfE6/E5TPTo12 m9TCyPbeoemCmpsid2NQEoUdKjt3hCCr3HHmj7Bd9+RpmxeFPIgAQg64UdlSetFybyUO 5rHaWk3pwydYHADGIn4YYsfIGk+4DzmUroNg5pSmQeQWhloF21CiYEIEOSbTguaEyRvI xaeQ== Received: by 10.68.229.169 with SMTP id sr9mr1708930pbc.164.1332990038103; Wed, 28 Mar 2012 20:00:38 -0700 (PDT) Received: from imsuperman-PC ([218.61.139.119]) by mx.google.com with ESMTPS id x1sm3968263pbp.50.2012.03.28.20.00.35 (version=SSLv3 cipher=OTHER); Wed, 28 Mar 2012 20:00:37 -0700 (PDT) Date: Thu, 29 Mar 2012 11:00:36 +0800 From: superman0920 To: pgsql-admin Reply-To: superman0920 Subject: about encoding X-Priority: 3 X-GUID: 5E7C6932-0BA8-4D9A-89D7-A53EECD29699 X-Has-Attach: no X-Mailer: Foxmail 7.0.1.88[cn] Mime-Version: 1.0 Message-ID: <201203291100302033066@gmail.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart333461281737_=----" X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201203/145 X-Sequence-Number: 39333 This is a multi-part message in MIME format. ------=_001_NextPart333461281737_=---- Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 aGVsbG8NCmkgd2FudCB0byBpbnNlcnQgYSByZXBvcnQgdG8gcG9zdGdyZXNxbKOsdGhlIHJlcG9y dCBjb250YWluIHNvbWV0aGluZyBDaGluZXNlIGNoYXJhY3RlcnMgYW5kIHRoZSBwb3N0Z3Jlc3Fs IGlzIHV0Zi04Lg0KDQp0aGUgcmVzcG9uc2UgZnJvbSBkYiBpcyB0aGlzOiANCkVSUk9SOiAgaW52 YWxpZCBieXRlIHNlcXVlbmNlIGZvciBlbmNvZGluZyAiVVRGOCI6IDB4YjEgDQoNCmhvdyBjYW4g aSBmaXggaXQgPyANCg0KdGh4DQoNCg0KDQoNCnN1cGVybWFuMDkyMA== ------=_001_NextPart333461281737_=---- Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

hello

i want to insert a report to postgresql=A3=ACthe report contain somet= hing=20 Chinese characters and the postgresql is utf-8.

the response from db is this:

ERROR: invalid byte sequence= for encoding "UTF8": 0xb1=20

how can i fix it ?

thx

superman0920

------=_001_NextPart333461281737_=------