Am 23.06.2010 22:02, schrieb Klaus Feichtinger:
According information I found in the PostgreSQL
manual, the data type
"BYTEA" is already representing a postgres-like binary data format.
Excerpt of the documentation
(
http://www.postgresql.org/docs/8.3/static/datatype-binary.html):
"The bytea data type allows storage of binary strings. [...] The SQL
standard defines a different binary string type, called BLOB or BINARY
LARGE OBJECT. The input format is different from bytea, but the provided
functions and operators are mostly the same."
"Real" BLOB (according SQL definition) is therefore not supported by
postgres. This page (documentation of binary data types) includes
examples of literal escaped octets, too. Maybe is is helpful for developers.
That sounds more complex and we still have to use the E'' prefix. I
think it would be easier to just add the E'' prefix to the current code.
But now I wonder what data type is used currently - the recent bug
report on the bug-tracker mentions problems with BLOB, which would
indicate that the body is already saved as BLOB.
IIRC you said you already tried adding the E'' prefixes to the
db_postgresql code. Does this, together with the \0 patch from the
bug-tracker solve your problems?
regards
klaus
regards
klaus