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
|
isXblob - geom - TinyPoint
:memory: #use in-memory database
SELECT Hex(blob), IsPngBlob(blob), IsGifBlob(blob), IsGeometryBlob(blob), IsTinyPointBlob(blob), IsZipBlob(blob), IsPdfBlob(blob), IsTiffBlob(blob), IsJpegBlob(blob), IsExifBlob(blob), IsExifGpsBlob(blob), IsWebpBlob(blob) FROM (SELECT GeomFromText('POINT(1 3)') as blob) dummy
1 # rows (not including the header row)
12 # columns
Hex(blob)
IsPngBlob(blob)
IsGifBlob(blob)
IsGeometryBlob(blob)
IsTinyPointBlob(blob)
IsZipBlob(blob)
IsPdfBlob(blob)
IsTiffBlob(blob)
IsJpegBlob(blob)
IsExifBlob(blob)
IsExifGpsBlob(blob)
IsWebpBlob(blob)
00810000000001000000000000F03F0000000000000840FE
0
0
0
1
0
0
0
0
0
0
0
|
