All Questions
370
questions
-1
votes
1
answer
31
views
Does SQLite3 compress data
Trying to hack a .db save of a game, here is where one piece of data that should read:
2f 47 61 6d 65 2f 4d 61 70 73 2f 4c 65 76 65 6c 30 31
2f 4c 65 76 65 6c 30 31
5f 4d 61 69 6e 2e
4c 65 76 65 6c 30 ...
- 39
0
votes
0
answers
57
views
Putting Image file into SQLite Blob field with VB.Net
I have been attempting to put an image file into an SQLite blob field.
The code runs as I would expect but nothing is added to the table. If I try and run the same code again it errors with the ...
- 1
1
vote
1
answer
48
views
In flutter and dart, how to query a blob column?
the sqlite database table is created as:
CREATE TABLE Books (id INTEGER PRIMARY KEY AUTOINCREMENT, path TEXT, hash blob);
CREATE UNIQUE INDEX path_uni ON Books(path);
CREATE ...
- 11
0
votes
1
answer
40
views
How to use SQLiteBlob when rowId is not an integer?
How can SQLLiteBlob be used oder replace by another method when the rowId is a string?
Here the sample code.
public void WriteContent(Stream contentStream, string table, string rowId)
{
...
1
vote
2
answers
473
views
How to save PDF files to a SQLite database using Python
Can someone give me an example of what the function would be like to read the pdf file and convert it to binary so I can store it in the database.
- 13
0
votes
0
answers
54
views
Images from sqlite3 database do not display in treeview tkinter
I am creating a GUI which displays data in a treeview from a sqlite database. I have managed to dsiplay the text and integer data. However, images are still a problem. I have referred to so many ...
- 5
0
votes
1
answer
492
views
How to query a blob column in @capacitor-community/sqlite in Android platform
I have a pre-populated test sqlite db with a table with blob column where png image is saved. I'm trying to query it in an ionic/angular/capacitor with @capacitor-community/sqlite platform running in ...
- 21
0
votes
0
answers
160
views
Retrieving float and binary data sqlite3
I have a database in sqlite
This database contains strings, floats and column with BLOB values. These BLOB values contain binary data that it has to be converted to float numbers
I was wondering ...
- 1,084
0
votes
2
answers
1k
views
Flutter: How to store Image as blob in Sqlite & how to retrieve it?
I'm using Flutter, I need to save image in SQLite as BLOB, then display it in my page.
I did it as String and it works fine but not image with 1.5 MB size, the app get unhanded exception, I tried to ...
1
vote
0
answers
151
views
How to create image from BLOB?
I am trying to pull images from an SQLite database from a cell phone application (used to perform personal spirometry: lung function testing).
I have been able to access all the numerical data I need, ...
- 21
0
votes
1
answer
1k
views
Why does SQLite store strings as text in BLOB columns, rather than bytes?
This behavior has me scratching my head: apparently, when you store a string into a BLOB column, when you query it it doesn't behave like bytes? And, weirder still, when you attempt to perform a BLOB ...
- 4,570
2
votes
1
answer
408
views
How to unnest an integer array represented as a BLOB?
SQLite doesn’t have native support for arrays. I would think that my method (thinking outlined below) of making a custom BLOB encoding would be a fairly common workaround (yes, I need an array rather ...
- 57
1
vote
0
answers
85
views
Update one variable from Blob Object in SQLite
I had a app with version 3.2.1 and release version 3.2.2 now.
In version 3.2.1 , I had an object with 2 variable for example Name and Email.
at First , I Converted The Object to Byte with this code:
...
- 108
1
vote
1
answer
132
views
Migrate field BLOB in table mysql to field BLOB in table sqlite
I have a table containing one column BLOB type in database mysql. I want export to sqlite database with similar structure, but in sqlite database the destination table throws error for too long bytes
...
- 11
0
votes
0
answers
350
views
How to upload into and download from SQLite database doc file in C# .NET?
I have decided to develop desktop program with usage of SQLite datatbase and with help of C# programming language. One of the necessary functions that must be present is uploding the doc file into ...
