Constructs a geometry from a binary string representation.
ST_Geometry::ST_GeomFromBinary(binary-string[, srid])
Name | Type | Description |
---|---|---|
binary-string |
LONG BINARY |
A string containing the binary representation of a geometry. The input can be in any supported binary format, including WKB or EWKB. |
srid |
INT |
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.
The spatial reference system identifier of the result is the given by parameter srid.
Parses a string containing one of the supported formats and creates a geometry value of the appropriate type. This method is used by the server when evaluating a cast from a binary string to a geometry type.
Some input formats contain a SRID definition. If provided, the srid parameter must match any value taken from the input string.
SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension
The following example returns the result Point (10 20)
.
SELECT ST_Geometry::ST_GeomFromBinary( 0x010100000000000000000024400000000000003440 ) |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |