| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: invalid byte sequence for encoding "UTF8": 0x00 |
| Date: | 2014-08-30 17:21:41 |
| Message-ID: | VisenaEmail.19.2d1a83e32f2eda79.14827ebcb25@tc7-on |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc |
På fredag 29. august 2014 kl. 11:54:35, skrev Albe Laurenz <
laurenz(dot)albe(at)wien(dot)gv(dot)at <mailto:laurenz(dot)albe(at)wien(dot)gv(dot)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(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lalit jangra | 2014-08-31 16:45:33 | Fwd: Getting invalid page header in block while vacuuming PostgreSQL DB. |
| Previous Message | lalit jangra | 2014-08-30 17:12:31 | Getting invalid page header in block while vacuuming PostgreSQL DB. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | liuyuanyuan | 2014-09-01 02:04:24 | 答复: [JDBC] invalid byte sequence for encoding "UTF8": 0x00 |
| Previous Message | Albe Laurenz | 2014-08-29 09:54:35 | Re: invalid byte sequence for encoding "UTF8": 0x00 |