1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
isXblob - jpeg with (token) EXIF header
:memory: #use in-memory database
SELECT Hex(blob), IsPngBlob(blob), IsGifBlob(blob), IsGeometryBlob(blob), IsZipBlob(blob), IsPdfBlob(blob), IsTiffBlob(blob), IsJpegBlob(blob), IsExifBlob(blob), IsExifGpsBlob(blob), IsWebpBlob(blob) FROM (SELECT BlobFromFile('sql_stmt_tests/ktorrent_grad1.jpg') as blob) dummy
1 # rows (not including the header row)
11 # columns
Hex(blob)
IsPngBlob(blob)
IsGifBlob(blob)
IsGeometryBlob(blob)
IsZipBlob(blob)
IsPdfBlob(blob)
IsTiffBlob(blob)
IsJpegBlob(blob)
IsExifBlob(blob)
IsExifGpsBlob(blob)
IsWebpBlob(blob)
FFD8FFE000104A46494600010101004800480000FFE100164578696600004D4D002A00000008000000000000FFFE0017437265617465642077697468205468652047494D50FFDB0043000503040404030504040405050506070C08070707070F0B0B090C110F1212110F111113161C1713141A1511111821181A1D1D1F1F1F13172224221E241C1E1F1EFFDB0043010505050706070E08080E1E1411141E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1E1EFFC00011080014000103012200021101031101FFC400160001010100000000000000000000000000000607FFC4001C1001000104030000000000000000000000000401031453151661FFC40017010003010000000000000000000000000003040607FFC400161101010100000000000000000000000000000313FFDA000C03010002110311003F0087EB9E8B6E62269B225729361D6CCC33E56CA8019F7FFFD9
0
0
0
0
0
0
1
1
0
0
|
