Re: invalid byte sequence for encoding "UTF8": 0x00

From: JasmineLiu <liuyuanyuangogo(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Date: 2014-08-27 07:43:18
Message-ID: 1409125398008-5816498.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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
PostgreSQL.
SQLServer 2008 R2, encoding :GBK
PostgreSQL 9.3.4, encoding:UTF8

Rather than modify the column value in sql server,
are there any other ways to solve this problem?
Better to give me an examples.
Thanks!

Yours,
Jasmine

--
View this message in context: http://postgresql.1045698.n5.nabble.com/invalid-byte-sequence-for-encoding-UTF8-0x00-tp2172080p5816498.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2014-08-27 08:11:09 Re: invalid byte sequence for encoding "UTF8": 0x00
Previous Message Peter Eisentraut 2014-08-26 21:24:23 Re: pg_basebackup man-page confusion?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Albe Laurenz 2014-08-27 08:11:09 Re: invalid byte sequence for encoding "UTF8": 0x00
Previous Message David G Johnston 2014-08-26 18:37:32 Re: How to implement a dynamic string into a sql statement?