ST_GeomFromBinary(LONG BINARY, INT) method

Constructs a geometry from a binary string representation.

Syntax

ST_Geometry::ST_GeomFromBinary(LONG BINARY binary_string, INT srid)

binary_string – A string containing the binary representation of a geometry. The input can be in any supported binary format, including WKB or EWKB.
srid – The SRID of the result. If not specified and the input string does not provide a SRID, the default is 0.

ST_Geometry Returns a geometry value of the appropriate type based on the source string.

Example 1 – The following example returns the result Point (10 20).

SELECT ST_Geometry::ST_GeomFromBinary( 0x010100000000000000000024400000000000003440 )

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension