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
