Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

st_geometry_asbinary_format option

Controls how spatial values are converted from a geometry to binary.

Allowed values

The list of values supported for this option is identical to the list of parameters (including sub-parameters) documented for the ST_AsBinary method.



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No

This option is used to determine how a geometry is converted to binary. The following are the two main contexts in which the option is used:

  • fetching a value as binary from a client application

  • executing a CAST statement. For example: CAST( geometry-expression AS LONG BINARY )

Assignments from geometry types to BINARY types give an error in contexts other than fetching from a client application and the CAST statement. For example, you cannot call a function or procedure that takes a BINARY parameter and pass a geometry, nor can you assign a geometry to a LONG BINARY variable.