ST_WKTtoWKB function

The WKTtoWKB function takes a well-known-text (WKT) format of a geography and returns the corresponding geometry in a well-known-binary (WKB) format.

If the specified WKT format is null, then null is returned.

The ST_WKTtoWKB function gives the same result as ST_AsText(ST_GeomFromBinary()).

Syntax

Read syntax diagramSkip visual syntax diagram ST_WKTtoWKB ( geometry ,srs_id )

Parameter

geometry
A value of type VARCHAR or CLOB(2G) that contains the WKT format of the geometry to be converted.
srs_id
A value of type INTEGER that uniquely identifies the spatial reference system. The default value for the srs_id is 4326.

Return type

Returns a type BLOB(2G) that contains the WKB format of a geometry object.