From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-jdbc@postgresql.org
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Date: Sat, 30 Aug 2014 19:21:41 +0200 (CEST)
Message-ID: <VisenaEmail.19.2d1a83e32f2eda79.14827ebcb25@tc7-on> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B17D2FA97@ntex2010i.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-jdbc>
På fredag 29. august 2014 kl. 11:54:35, skrev Albe Laurenz <
laurenz.albe@wien.gv.at <mailto:laurenz.albe@wien.gv.at>>: Joseph Krogh wrote:
>> 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.
I was talking about characters, not bytes. '\0' is a character. I see noe
specification of character-fields (like varchar and text) in your answer. --
Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com> www.visena.com
<https://www.visena.com; <https://www.visena.com;
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: andreas@visena.com, pgsql-jdbc@postgresql.org
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
In-Reply-To: <VisenaEmail.19.2d1a83e32f2eda79.14827ebcb25@tc7-on>
* 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