24 Jun
2010
24 Jun
'10
7:49 p.m.
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