From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: 'Andreas Joseph Krogh-2 [via PostgreSQL]' <ml-node+s1045698n5816732h11@n5.nabble.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Date: Fri, 29 Aug 2014 09:09:03 +0800
Message-ID: <001f01cfc325$d614fe20$823efa60$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Thanks Andreas!
I like this clear answer!
My colleague and I have found about this in PostgreSQL source code, but we’re not so sure.
Thanks for your reply!
Regards!
Jasmine Liu
发件人: Andreas Joseph Krogh-2 [via PostgreSQL] [mailto:ml-node+s1045698n5816732h11@n5.nabble.com]
发送时间: 2014年8月28日 20:46
收件人: JasmineLiu
主题: Re: invalid byte sequence for encoding "UTF8": 0x00
På onsdag 27. august 2014 kl. 10:11:09, skrev Albe Laurenz <[hidden email]>:
JasmineLiu wrote:
> 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.
You will never be able to insert a null character into a PostgreSQL database.
You can either modify the source data or change the data in transit.
This is not 100% true, but is true for text-fields. You can insert \0 into BYTEA columns.
Usually the \0 isn't important so you can do this in JAVA before inserting into PG:
someString.replace('\0', ' ') or someString.replaceAll("\0", "")
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
[hidden email]
www.visena.com <https://www.visena.com;
<https://www.visena.com;
_____
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/invalid-byte-sequence-for-encoding-UTF8-0x00-tp2172080p58167...
To unsubscribe from invalid byte sequence for encoding "UTF8": 0x00, click here <http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=...; .
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_h...; NAML
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, ml-node+s1045698n5816732h11@n5.nabble.com
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
In-Reply-To: <001f01cfc325$d614fe20$823efa60$@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