pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: 'Albe Laurenz' <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org
Subject: 答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00
Date: Mon, 1 Sep 2014 10:04:24 +0800
Message-ID: <006001cfc589$1102c7a0$330856e0$@gmail.com> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B17D2FAAE@ntex2010i.host.magwien.gv.at>
References: <BAY7-F17FFE0E324AB3B642C547E96890@phx.gbl>
	<45DAE076.1060407@opencloud.com>
	<45DD3A3F.5050609@kensystem.com>
	<E5CB7F50-AA37-4986-A2F7-E74F255BF4B6@pvv.ntnu.no>
	<1409125398008-5816498.post@n5.nabble.com>
	<A737B7A37273E048B164557ADEF4A58B17D2EDBA@ntex2010i.host.magwien.gv.at>
	<1409127765169-5816502.post@n5.nabble.com>
	<A737B7A37273E048B164557ADEF4A58B17D2EE01@ntex2010i.host.magwien.gv.at>
	<002801cfc1d4$143f1620$3cbd4260$@gmail.com>
	<A737B7A37273E048B164557ADEF4A58B17D2EF84@ntex2010i.host.magwien.gv.at>
	<001e01cfc260$d5d3f300$817bd900$@gmail.com>
	<A737B7A37273E048B164557ADEF4A58B17D2FAAE@ntex2010i.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Hi, Laurenz Albe!
Thanks for all your help! I've understand. Thank you so much!

Best Regards!
Jasmine


-----邮件原件-----
发件人: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] 
发送时间: 2014年8月29日 17:58
收件人: liuyuanyuan *EXTERN*
主题: RE: [JDBC] invalid byte sequence for encoding "UTF8": 0x00

> Are there other error encoded Strings that I haven't catch?
> If there other error encoded String occurs, maybe my program will catch exception again.
> Is there a foolproof method that could resolve all problem caused by encoding ?

To the best of my knowledge, all you need to check is if the data is valid
UTF-8 and does not contain a \u0000 character.
Then PostgreSQL should not have a problem with it (the server encoding is UTF8, otherwise it may be that the server cannot store a valid character).

Yours,
Laurenz Albe



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



Message-ID: <006001cfc589$1102c7a0$330856e0$@gmail.com>
Permalink:  ../006001cfc589$1102c7a0$330856e0$@gmail.com/
Also on:    postgresql.org/message-id/006001cfc589$1102c7a0$330856e0$@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: liuyuanyuangogo@gmail.com, laurenz.albe@wien.gv.at
  Subject: Re: 答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00
  In-Reply-To: <006001cfc589$1102c7a0$330856e0$@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox