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
28
29
30
|
isXblob - RIFF, not Webp
: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), GeomFromExifGpsBlob(blob), IsWebpBlob(blob) FROM (SELECT BlobFromFile('sql_stmt_tests/seconds.wav') as blob) dummy
1 # rows (not including the header row)
12 # columns
Hex(blob)
IsPngBlob(blob)
IsGifBlob(blob)
IsGeometryBlob(blob)
IsZipBlob(blob)
IsPdfBlob(blob)
IsTiffBlob(blob)
IsJpegBlob(blob)
IsExifBlob(blob)
IsExifGpsBlob(blob)
GeomFromExifGpsBlob(blob)
IsWebpBlob(blob)
524946467C01000057415645666D74201200000007000100401F0000401F000001000800000066616374040000004A010000646174614A010000523B2832AC9EAE2E3D61432B2BB49FA43B3560493827D5A2A0F62E5E4B3D293EA79EB52D4B4B3B2B2CB09DA53435593E3728F7A19E682D5E4B3E2737A89DBB2B4E56442D2EAD9CAA2F3E59453126C09E9F40306B41392544A49ED12EEF4C41292EAB9DB52C42624C3029BA9EA837397E4C3A27649F9F5C3463473D283BA89EBD304D45422E2DAF9DAB3540523C3328D29FA24534553E392A4DA29ED5315C423E2D32AC9EB3344F5644322AB99EA83D37504139284CA1A0713250483E2A38A89EBC2E44574D2F2CB49DAA343C5E443627DF9EA247345E4B3F273FA19FDD2D4949442C2FA99DB4303F6446302ABB9DA83C35584A3D284EA09F7D314E3E3F2A36A59DBC2E4E4B442F2BB29EAB3336574B3B28E89FA24D3150503E2646A29FDA2D4851522C32AA9DB52E3E4D4E312AB79DA733335D563B27E99FA2462D584C3F2941A29ECB2C4449402D31AB
0
0
0
0
0
0
0
0
0
(NULL)
0
|
