Re: invalid byte sequence for encoding "UTF8": 0x00

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Andreas Joseph Krogh *EXTERN*" <andreas(at)visena(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00
Date: 2014-08-29 09:54:35
Message-ID: A737B7A37273E048B164557ADEF4A58B17D2FA97@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeffrey Shaw 2014-08-29 13:54:27 psql on Linux vs Windows, major GSS differences
Previous Message Saravanan.S 2014-08-29 05:46:28 Re: Table Partition

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andreas Joseph Krogh 2014-08-30 17:21:41 Re: invalid byte sequence for encoding "UTF8": 0x00
Previous Message liuyuanyuan 2014-08-29 01:09:03 Re: invalid byte sequence for encoding "UTF8": 0x00