On 2012/3/2, at 下午4:50, Alexander Huemer wrote:
I remember that somebody stumbled over a weirdness in the way the data
is actually stored in the DB (sqlite), which was caused by the DBI
layer.
That would be me. To recap: libdbi (c lib) store binary value in its own way.
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.
Sincerely,
Kang-min Liu