The blog discusses the manual approach to read BLOB data type but as it is not in human readable form,the blog covers quick solution to read and analyze the SQLite BLOB data type.I am using SQLite in a Java application through Zentus. ConclusionīLOB data type contains binary data. This enables user to access the collected artifacts in various platforms. Various exporting formats supported by the tool are CSV, PDF and HTML. The recovered artifacts can be exported and saved in different file formats. This is the backup file for the original data file so these can be the major residence of digital evidences. The tool is capable to recover the associated journal files related to SQLite file. This helps the investigator in deeply analyzing the database file. User can view and analyze contents form the SQLite database in tabular form or in hexadecimal form. these deleted items are listed in separate tab so that investigator can analyze these contents easily. The tool is capable to recover the deleted contents from the SQLite files. SQLite Forensic tool allows users to preview and analyze tables, structures, byte code, and the multimedia contents from BLOB data type. Prominent Features of SQLite Forensics tool Suggested Solution- SQLite ForensicsĮxplore & Extract SQLite Database files using SQLite Forensic Tool. To overcome this limitation investigator can use a smart tool to view and analyze SQLite BLOB data contents. Moreover, the investigator should be an expert in database management. This is not a reliable method to view and analyze data from BLOB as it is not in a human readable format. SQLite provide another Query ‘quote’ to view the contents in Hex format. Here, you can see that the contents are not in human readable format. Sqlite> select ''||b_id from blob_test ?#Egë½-n?#Egë½-n Sqlite> select * from blob_test ?#Egë½-n?#Egë½-n Viewing BLOB contents using SELECT query: Sqlite> create table blob_test (b_id blob) Simple SQL queries can be used to view and analyze BLOB data contents. Since BLOB contains binary data, the viewing and analyzing of BLOB data is very difficult for human to understand.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |