Quick Links

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

From:	Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To:	"JasmineLiu EXTERN" <liuyuanyuangogo(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject:	Re: invalid byte sequence for encoding "UTF8": 0x00
Date:	2014-08-27 08:44:34
Message-ID:	A737B7A37273E048B164557ADEF4A58B17D2EE01@ntex2010i.host.magwien.gv.at
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin pgsql-jdbc

JasmineLiu wrote:
> Can you give me an example of changing the data in transit?

You export the data to a file, modify the file (with tools like sed
or something more complicated), and load the result.

Yours,
Laurenz Albe

In response to

Re: invalid byte sequence for encoding "UTF8": 0x00 at 2014-08-27 08:22:45 from JasmineLiu

Responses

答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00 at 2014-09-01 02:04:24 from liuyuanyuan

Browse pgsql-admin by date

	From	Date	Subject
Next Message	czezz	2014-08-27 15:04:34	SQL statement form shell ?
Previous Message	JasmineLiu	2014-08-27 08:22:45	Re: invalid byte sequence for encoding "UTF8": 0x00

Browse pgsql-jdbc by date

	From	Date	Subject
Next Message	Andreas Joseph Krogh	2014-08-28 12:45:23	Re: invalid byte sequence for encoding "UTF8": 0x00
Previous Message	Craig Ringer	2014-08-27 08:28:14	Re: How to implement a dynamic string into a sql statement?