-
-
Notifications
You must be signed in to change notification settings - Fork 2.2k
Closed
Labels
bugConfirmed bugs or reports that are very likely to be bugs.Confirmed bugs or reports that are very likely to be bugs.
Milestone
Description
BLOB data imported from file is not typed BLOB but TEXT.
We can replicate by following way.
- create table
CREATE TABLE 'Sample' ('ID' INTEGER, 'Image' BLOB, PRIMARY KEY(ID))
- add new record on "Browse Data" tab
- update 'Image' data by importing image file(e.g. jpg file) on 'Edit database cell'
- query type of 'Image' data, and get TEXT type
SELECT typeof(Image) FROM Sample
Maybe, the reason of this issue is DBBrowserDB::updateRecord(sqlitedb.cpp) method.
Imported data for update bind by sqlite3_bind_text without reference to actual (or estimated) data type.
Metadata
Metadata
Assignees
Labels
bugConfirmed bugs or reports that are very likely to be bugs.Confirmed bugs or reports that are very likely to be bugs.