These functions take as arguments a
BLOB
containing a Well-Known Binary
(WKB) representation and, optionally, a spatial reference system
identifier (SRID). They return the corresponding geometry.
GeomFromWKB()
and
ST_GeomFromWKB()
accept a WKB value
of any geometry type as their first argument. Other functions
provide type-specific construction functions for construction of
geometry values of each geometry type.
These functions also accept geometry objects as returned by the functions in Section 12.17.5, “MySQL-Specific Functions That Create Geometry Values”. Thus, those functions may be used to provide the first argument to the functions in this section.
For a description of WKB format, see Well-Known Binary (WKB) Format.
GeomCollFromWKB(
,wkb
[,srid
])GeometryCollectionFromWKB(
wkb
[,srid
])ST_GeomCollFromWKB()
,ST_GeometryCollectionFromWKB()
,GeomCollFromWKB()
, andGeometryCollectionFromWKB()
are synonyms. For more information, see the description ofST_GeomCollFromWKB()
.GeomFromWKB(
,wkb
[,srid
])GeometryFromWKB(
wkb
[,srid
])ST_GeomFromWKB()
,ST_GeometryFromWKB()
,GeomFromWKB()
, andGeometryFromWKB()
are synonyms. For more information, see the description ofST_GeomFromWKB()
.LineFromWKB(
,wkb
[,srid
])LineStringFromWKB(
wkb
[,srid
])ST_LineFromWKB()
,ST_LineStringFromWKB()
,LineFromWKB()
, andLineStringFromWKB()
are synonyms. For more information, see the description ofST_LineFromWKB()
.MLineFromWKB(
,wkb
[,srid
])MultiLineStringFromWKB(
wkb
[,srid
])Constructs a
MultiLineString
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.MPointFromWKB(
,wkb
[,srid
])MultiPointFromWKB(
wkb
[,srid
])Constructs a
MultiPoint
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.MPolyFromWKB(
,wkb
[,srid
])MultiPolygonFromWKB(
wkb
[,srid
])Constructs a
MultiPolygon
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.ST_PointFromWKB()
andPointFromWKB()
are synonyms. For more information, see the description ofST_PointFromWKB()
.PolyFromWKB(
,wkb
[,srid
])PolygonFromWKB(
wkb
[,srid
])ST_PolyFromWKB()
,ST_PolygonFromWKB()
,PolyFromWKB()
, andPolygonFromWKB()
are synonyms. For more information, see the description ofST_PolyFromWKB()
.ST_GeomCollFromWKB(
,wkb
[,srid
])ST_GeometryCollectionFromWKB(
wkb
[,srid
])Constructs a
GeometryCollection
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.ST_GeomCollFromWKB()
,ST_GeometryCollectionFromWKB()
,GeomCollFromWKB()
, andGeometryCollectionFromWKB()
are synonyms.ST_GeomFromWKB(
,wkb
[,srid
])ST_GeometryFromWKB(
wkb
[,srid
])Constructs a geometry value of any type using its WKB representation and SRID.
The result is
NULL
if the WKB or SRID argument isNULL
.ST_GeomFromWKB()
,ST_GeometryFromWKB()
,GeomFromWKB()
, andGeometryFromWKB()
are synonyms.ST_LineFromWKB(
,wkb
[,srid
])ST_LineStringFromWKB(
wkb
[,srid
])Constructs a
LineString
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.ST_LineFromWKB()
,ST_LineStringFromWKB()
,LineFromWKB()
, andLineStringFromWKB()
are synonyms.Constructs a
Point
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.ST_PointFromWKB()
andPointFromWKB()
are synonyms.ST_PolyFromWKB(
,wkb
[,srid
])ST_PolygonFromWKB(
wkb
[,srid
])Constructs a
Polygon
value using its WKB representation and SRID.The result is
NULL
if the WKB or SRID argument isNULL
.ST_PolyFromWKB()
,ST_PolygonFromWKB()
,PolyFromWKB()
, andPolygonFromWKB()
are synonyms.