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
