ST_GeomFromText(LONG VARCHAR, INT) method

Syntax

ST_Geometry::ST_GeomFromText(LONG VARCHAR character_string, INT srid)

Parameters

• character_string – A string containing the text representation of a geometry. The input can be in any supported text input format, including Well Known Text (WKT) or Extended Well Known Text (EWKT).
• srid – The SRID of the result. If not specified and the input string does not contain a SRID, the default is 0.

Returns

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

Examples

• Example 1 – The following example returns the result LineString (1 2, 5 7).

  SELECT ST_Geometry::ST_GeomFromText( 'LineString( 1 2, 5 7 )', 4326 )

Standards

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