Postgres Pro
Downloads
Home   >   mailing lists

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

From Albe Laurenz
Subject Re: invalid byte sequence for encoding "UTF8": 0x00
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17D2FA97@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: invalid byte sequence for encoding "UTF8": 0x00  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: invalid byte sequence for encoding "UTF8": 0x00
List pgsql-jdbc
Tree view 
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.

Yours,
Laurenz Albe

pgsql-jdbc by date:

Previous
From: JasmineLiu
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00