On Jun 11, 2008, at 9:03 AM, Richard Huxton wrote:

Sim Zacks wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The data in the longblob field might be text, which could be causing the confusion. For example, when I look at the data in the longblob field, I
see /n for a newline and when I look at the bytea it is 012.

That's right - newline is ASCII 10 (or 12 in octal).

Just from the top of my head, but aren't mail headers supposed to be terminated by \r\n? In that case you're missing a byte 13 (or 015 octal) before the 012 byte. That could explain your missing line breaks.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4850140f927661409586227!



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to