Kang-min Liu wrote:
To recap: libdbi (c lib) store binary value in its own way.
Ahh. Thanks for this hint.
It escapes the value to make it fit in a SQL string, instead of sqlite3_bind_blob function to store the actual raw value. It bugged me because I was trying to read the db from a perl program. I ended up porting the escaping/unescaping subroutine to perl in order to read/write the SMS table.
We'll have to change this to a more powerful solution soon. (Maybe both some database bits but in particular SMSes.)
Kind regards
//Peter