Re: store in bytea

But Ill have to add double slashes and even more importent I will have to
unescape every binary data going out of the server, which mean in one of my
aplication all the Images.

Wont this action be much more heavey then the way I used untill now with
MySQL (blob) ?
addslash on insert and ordinary select for output.

Does any one here save his website images on DB and retrive them out on his
web page ?

> "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
>