I was looking through old posts and this one seemed quite similar to my
situation with one exception. I have full knowledge of what data I'm
trying to recover.
http://thread.gmane.org/gmane.comp.db.sqlite.general/35764

The basics, data was deleted from 4 tables via an ODBC connection. No
Vacuum has been done and looking at a copy of the database in a text
editor(Scite) I can see a lot of the data completely intact.

What I don't know is,
1.for the non-ascii characters in the file, what are they and how can I
translate the ones that might have say numeric data in them.(Text
appears to be just text)
2.is there a pattern of line starts/ends or other indicators that would
be useful for me to look for if I'm writing a script to parse the file
back into at least an unformatted text dump?

Is the "deleted" data in the "Free Pages" and is there anything in the
API to interact with data in this area so I could loop over it and
extract pieces one by one?

Any other leads I should be following?

Thanks,
Alex
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to