On Wednesday 23 June 2010, Klaus Feichtinger wrote:
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.
Hello Klaus,
the kamailio internal BLOB type is indeed mapped to the BYTEA type in postgres, as there is no native BLOB type comparing to e.g. mysql.
Regards,
Henning