--ST_GEOMFROMTEXT函数会根据给定的WKT和SRID返回一个ST_GEOMETRY数据--输出WKB不包含SRIDSELECT ST_AsBinary(ST_GeomFromText('POINT(1 2)')) res FROM DUAL;
RES ---------------------------------------------------------------- 0101000000000000000000F03F0000000000000040
SELECT ST_AsBinary(ST_GeomFromText('POINT(1 2)', 4326)) res FROM DUAL;
RES ---------------------------------------------------------------- 0101000000000000000000F03F0000000000000040
--大小端序SELECT ST_AsBinary(ST_GeomFromText('POINT(1 2)'), 'NDR') res FROM DUAL;
RES ---------------------------------------------------------------- 0101000000000000000000F03F0000000000000040
SELECT ST_AsBinary(ST_GeomFromText('POINT(1 2)'), 'XDR') res FROM DUAL;
RES ---------------------------------------------------------------- 00000000013FF00000000000004000000000000000 --box2d为点SELECT ST_AsBinary(BOX2D(1, 1, 2, 2)) res FROM DUAL;
RES----------------------------------------------------------------0101000000000000000000F03F0000000000000040
--box2d为线SELECT ST_AsBinary(BOX2D(1, 3, 2, 2)) res FROM DUAL;
RES----------------------------------------------------------------010200000002000000000000000000F03F000000000000004000000000000008400000000000000040
--box2d为矩形 SELECT ST_AsBinary(BOX2D(1, 3, 2, 3)) res FROM DUAL;
RES----------------------------------------------------------------01030000000100000005000000000000000000F03F0000000000000040000000000000F03F00000000000008400000000000000840000000000000084000000000000008400000000000000040000000000000F03F0000000000000040
评论