Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_asbinary below:

ST_AsBinary | MariaDB Documentation

1. Reference
2. SQL Statements
3. Geometry Statements
4. WKB

ST_AsBinary(g)
AsBinary(g)
ST_AsWKB(g)
AsWKB(g)

Converts a value in internal geometry format to its WKB representation and returns the binary result.

ST_AsBinary(), AsBinary(), ST_AsWKB() and AsWKB() are synonyms,

SET @poly = ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))');
SELECT ST_AsBinary(@poly);

SELECT ST_AsText(ST_GeomFromWKB(ST_AsWKB(@poly)));
+--------------------------------------------+
| ST_AsText(ST_GeomFromWKB(ST_AsWKB(@poly))) |
+--------------------------------------------+
| POLYGON((0 0,0 1,1 1,1 0,0 0))             |
+--------------------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4