Re: invalid byte sequence for encoding "UTF8": 0x00 - Mailing list pgsql-jdbc

From Andreas Joseph Krogh
Subject Re: invalid byte sequence for encoding "UTF8": 0x00
Date
Msg-id VisenaEmail.19.2d1a83e32f2eda79.14827ebcb25@tc7-on
Whole thread Raw
In response to Re: invalid byte sequence for encoding "UTF8": 0x00  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: invalid byte sequence for encoding "UTF8": 0x00
List pgsql-jdbc
På fredag 29. august 2014 kl. 11:54:35, skrev Albe Laurenz <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
 
Attachment

pgsql-jdbc by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Next
From: Albe Laurenz
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00