Re: store in bytea

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: "Joe Conway" <joseph(dot)conway(at)home(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: store in bytea
Date: 2001-08-24 13:28:17
Message-ID: 2905.998659697@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> writes:
> On the theoretical issue, can I use TEXT field to store binary ?

TEXT will not handle null (zero) bytes. If you are using a multibyte
character set, it will likely also do the wrong thing with byte
sequences that are illegal or incomplete multibyte characters.

Use BYTEA if you want to store arbitrary byte sequences --- that's what
it's for.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-24 13:29:27 Re: valid NULL DATE value
Previous Message Tom Lane 2001-08-24 13:23:50 Re: number of parameters to a stored procedure