Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 2839B1D983CB for ; Thu, 29 Mar 2012 00:22:55 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SD5wp-0002Wf-V6 for pgsql-admin@postgresql.org; Thu, 29 Mar 2012 03:22:54 +0000 Received: by pbcun15 with SMTP id un15so2734897pbc.19 for ; Wed, 28 Mar 2012 20:22:39 -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=CkPdH9H9jTRSq3NHNvgCY6v1G4jT0Nh7T1q2zkFZ2lY=; b=XVa5ffz4btc0wuL4iRdaS8bWJ3s/lpJQqxBs8qgN8CQ06xx52d+pEXvev8/QhaWl9s DJGA+sJZTrXiaOZckT7KHId89++NDql0Tgnwds5P6Q9UXNHFLbwLvZQXYTgMldngmb6V 4RrVnYNn8JVdE8q3flwRpG73WRu9KBTEDDVy7RS9EjMIrLBQ8uYCE3ZjbP/56hp1npCC E9KA96TmUbXCw/iyWooTATeQqCB5A1PUB3ejATIMpvMkD0HrfhqtRkoygSEdc1IRwfHU 2qXHNLhal6yXbAdr/blfYXEVzldKn9ER49NWyz6TA8rBIpjetCZQPC0wuh+SixjV/3h+ +33Q== Received: by 10.68.131.1 with SMTP id oi1mr1853271pbb.102.1332991359143; Wed, 28 Mar 2012 20:22:39 -0700 (PDT) Received: from imsuperman-PC ([218.61.139.119]) by mx.google.com with ESMTPS id f2sm4019461pbr.16.2012.03.28.20.22.35 (version=SSLv3 cipher=OTHER); Wed, 28 Mar 2012 20:22:38 -0700 (PDT) Date: Thu, 29 Mar 2012 11:22:36 +0800 From: superman0920 To: pgsql-admin Reply-To: superman0920 Subject: about encoding X-Priority: 3 X-GUID: C8BBC1C6-48CC-42AA-AE2F-A950AEB26122 X-Has-Attach: no X-Mailer: Foxmail 7.0.1.88[cn] Mime-Version: 1.0 Message-ID: <201203291122317598487@gmail.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart626812110821_=----" X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201203/129 X-Sequence-Number: 39317 This is a multi-part message in MIME format. ------=_001_NextPart626812110821_=---- Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 aGVsbG8NCmkgd2FudCB0byBpbnNlcnQgYSByZXBvcnQgdG8gcG9zdGdyZXNxbKOsdGhlIHJlcG9y dCBjb250YWluIHNvbWV0aGluZyBDaGluZXNlIGNoYXJhY3RlcnMgYW5kIHRoZSBwb3N0Z3Jlc3Fs IGlzIHV0Zi04Lg0KDQp0aGUgcmVzcG9uc2UgZnJvbSBkYiBpcyB0aGlzOiANCkVSUk9SOiAgaW52 YWxpZCBieXRlIHNlcXVlbmNlIGZvciBlbmNvZGluZyAiVVRGOCI6IDB4YjEgDQoNCmhvdyBjYW4g aSBmaXggaXQgPyANCg0KdGh4DQoNCg0KDQoNCnN1cGVybWFuMDkyMA== ------=_001_NextPart626812110821_=---- 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_NextPart626812110821_=------