Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XMXt5-0005Eo-3B for pgsql-jdbc@arkaria.postgresql.org; Wed, 27 Aug 2014 07:43:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XMXt4-0004v0-Jb for pgsql-jdbc@arkaria.postgresql.org; Wed, 27 Aug 2014 07:43:22 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XMXt3-0004ut-Ju for pgsql-jdbc@postgresql.org; Wed, 27 Aug 2014 07:43:21 +0000 Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XMXt0-0002Os-QQ for pgsql-jdbc@postgresql.org; Wed, 27 Aug 2014 07:43:19 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1XMXt0-00036o-1C for pgsql-jdbc@postgresql.org; Wed, 27 Aug 2014 00:43:18 -0700 Date: Wed, 27 Aug 2014 00:43:18 -0700 (PDT) From: JasmineLiu To: pgsql-jdbc@postgresql.org Message-ID: <1409125398008-5816498.post@n5.nabble.com> In-Reply-To: References: <45DAE076.1060407@opencloud.com> <45DD3A3F.5050609@kensystem.com> Subject: Re: invalid byte sequence for encoding "UTF8": 0x00 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 3.2 (+++) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-jdbc Precedence: bulk Sender: pgsql-jdbc-owner@postgresql.org the context is: http://postgresql.1045698.n5.nabble.com/invalid-byte-sequence-for-encoding-= quot-UTF8-quot-0x00-td2172080.html I've also got this problem while copy or insert data from MS SQL Server to= =20 PostgreSQL. SQLServer 2008 R2, encoding :GBK PostgreSQL 9.3.4, encoding:UTF8 Rather than modify the column value in sql server,=20 are there any other ways to solve this problem? Better to give me an examples. Thanks=EF=BC=81 Yours=EF=BC=8C Jasmine -- View this message in context: http://postgresql.1045698.n5.nabble.com/inval= id-byte-sequence-for-encoding-UTF8-0x00-tp2172080p5816498.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com. --=20 Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc