Search Postgresql Archives

Re: encoding confusion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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!




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux