Binary data incorrectly detected as text/numeric in "Browse Data" · Issue #2197 · sqlitebrowser/sqlitebrowser · GitHub
Skip to content

Binary data incorrectly detected as text/numeric in "Browse Data" #2197

@mbrijun

Description

@mbrijun

Details for the issue

What did you do?

I have a SQLite table database with 76944 rows. The table has a BLOB column. All entries, except for the two entries below, are correctly identified as "binary" by the "Browse Data" tab.

0000  ff fe cf 62 24 7c 80 37 49 b3 ed 1e 28 70 1f e8  ...b$|.7I...(p.. 
0010  b9 ad c3 d4 25 75 f9 29 22 37 e6 f8 36 d7 43 6c  ....%u.)"7..6.Cl 
0000  ff fe 64 4c 2a e4 37 4c 50 57 48 33 91 12 dd b4  ..dL*.7LPWH3.... 
0010  95 cd 83 a4 95 91 93 d9 b9 2c 57 ec b8 c9 12 08  .........,W..... 

What did you expect to see?

With "Automatically Adjust the editor mode to the loaded data type" enabled, I expected it to detect "Binary".

What did you see instead?

The autodetection detected these 2 cells as Text/Numeric. I had to disable autodetection and force the mode to "binary" to see the actual data. This may potentially be related to the bug 1772.

image

image

Useful extra information

DB4S v3.11.2 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.18362) [x86_64]
using SQLite Version 3.27.2
and Qt 5.11.3

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions