1
2
3
4
5
6
7
8
9
|
fromWkb - mixed big-little-endian sub-items (1)
:memory: #use in-memory database
SELECT AsText(GeomFromWkb(CastToBlob('01070000000300000000000000013FF000000000000040000000000000000000000002000000020000000000000000000000000000000040140000000000004024000000000000010300000002000000050000000000000000000000000000000000000000000000000024400000000000000000000000000000244000000000000024400000000000000000000000000000244000000000000000000000000000000000050000000000000000001440000000000000144000000000000018400000000000001440000000000000184000000000000018400000000000001440000000000000184000000000000014400000000000001440', 1)));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromWkb(CastToBlob('01070000000300000000000000013FF000000000000040000000000000000000000002000000020000000000000000000000000000000040140000000000004024000000000000010300000002000000050000000000000000000000000000000000000000000000000024400000000000000000000000000000244000000000000024400000000000000000000000000000244000000000000000000000000000000000050000000000000000001440000000000000144000000000000018400000000000001440000000000000184000000000000018400000000000001440000000000000184000000000000014400000000000001440', 1)))
GEOMETRYCOLLECTION(POINT(1 2), LINESTRING(0 0, 5 10), POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (5 5, 6 5, 6 6, 5 6, 5 5)))
|
