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 - png
: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/k3b-icon.png') as blob) dummy
1 # rows (not including the header rows)
11 # columns
Hex(blob)
IsPngBlob(blob)
IsGifBlob(blob)
IsGeometryBlob(blob)
IsZipBlob(blob)
IsPdfBlob(blob)
IsTiffBlob(blob)
IsJpegBlob(blob)
IsExifBlob(blob)
IsExifGpsBlob(blob)
IsWebpBlob(blob)
89504E470D0A1A0A0000000D4948445200000010000000100803000000282D0F5300000231504C54450000009FA1ACA1A0AAAFB2B7A3A7ADAFB2B7919AABADA796AFB4B6B7BBBDBCC0C4BEC4C62122239FA495B9BDBFBFC3C5000000000000121212131313989CA4A2A7AD989CA5A2A7AD5E61640000000404040000000303039B9FA79EA2A99A9FA79EA3A91D1E1E1A1B1C1415162A2B2D2B2C2E212223979CA9AB9AA2B4B8BCADB2B6BCC0C3C8CBCE504C535A585C737374767673EBE6E7F0F0F19CA7B1B1B39CC6C8CBCCCFD0D2D5D7D2D5D6A8A8A8ACACACB8B8B8888889878788B2B4BEB9AFB8D8DADEC1C4C9CCCED3F4F4F5E9D9CD898A8BBDC3C98E8E8E959595E7E7E718181E1B1B2123222927252E3231393938423E3D4441404B4A49504C4B574C4C504F4F5651515559585E59585F5958605A5A5F5D5C645E5E625F60687272757B7C7F7D7C818080868686898A8A8C8F8E90908F9493939495949696969B9797989A9A9B9F9FA1A3A2A7AAAAADB4B4B5B6B6B7B8B8BCB9B9BDB9B9BEC2C7D8C3C3C5C6CEDBC7C8D0C7C8D1CBCCCCD1D8E4D2D4C5D4D4DFD4D7E3D5D6DED6C2BDD7D7DED7D8DDD9D9D9DACBD3DAD7BFDADAE2DBDBE2DBDCE3DBDECDDCD6DEDFE0E7E0E0E7E0E1E7E1CCCDE2D8DEE3E5ECE4DAC6E4E6D5E5E4EAE5E5E6E5E5EBE8E7ECE9D9DBE9E9ECEBE8EDEBEBEFEBEBF0ECECF1EDEDF1EFEEF2F1F1F4F2F2F4F2F3F3F3F3F4F3F3F5F3F3F6F4F4F6F4F4F7F5F5F6F6F6F6F6F6F8F6F7F7F7F7F7F7F7F8F7F7F9F8F8FAF9F9FAF9F9FBFBFBFBFBFBFCFBFBFDFCFBFCFCFCFCFCFCFDFDFDFEFEFEFDFEFEFEFEFEFFFEFFFFFFFFFF42B14FFC0000004A74524E53000B0B0B0D0D111111111213212526282D303F404B4B4C4D585B5E60656C6C6D6E6F71768181858F9090929498C7C7C8C8D0D0DBDBDCDCDEDFE6E6E9F1F2F6F6F7F8F8F8F9FBFDFEFEFEC6B2B0FB0000010A4944415478DA35CF855242011445D163777737767762777777773776B762072A0662A2A0E0FD3A9FCCB03E60CF6CC829993B385AA84141DD3D6E8CB3329BE8AD0D39BDE0A1A9A50DEE19FF2EDC000C8D90C991E975EEE9D5CBB738420780C7CCE2EAC4CE05FF5D267DE3F900CAEC85ADDDBDD4D898F4CE8EB6D6145D988EAE6D1F250710E3B7EF809C60C7D9DC3F09F4A3F1DEAE86C101891BEC97995E90EF6D7FFBF58D544CAE309B3BE7BF26F93FD5940D57F7D4923354E2EF0522499AB0B0BCA2AAA494AC014FDEE787A0F939BFBBA8A0BE38C30AD00A133D5C36092B5BF27289220D01E8871E1F363E6666E76451B431FE697A25D4D1D78F6C3ECA44F1AB6AC962B9D8DA1801F8033208565E8EDAAFA30000000049454E44AE426082
1
0
0
0
0
0
0
0
0
0
|
