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_describe_type option

Controls how spatial values are described.

Allowed values
  • CHAR
  • NCHAR
  • BINARY
Default

CHAR

Scope
  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
Remarks

Spatial values are fetched as character or binary because client libraries do not support spatial types directly. The st_geometry_describe_type specifies how a geometry column or expression is described to the client. Many client applications use the describe type for a column or expression to determine the client data type used to fetch the column or expression. Some client applications ignore the describe type, so setting the st_geometry_describe_type may not have the desired effect.

If a geometry is fetched as a character string type, the st_geometry_astext_format option is used to determine how to convert the geometry to text. If fetched as a binary type, the st_geometry_asbinary_format option is used. These are the same rules used by a CAST statement.

In ODBC applications, the SQL_DESC_TYPE_NAME and SQL_DESC_LOCAL_TYPE_NAME field identifiers of SQLColAttribute return the string st_geometry for columns of any geometry type. In JDBC, this is expressed by using the ResultSetMetaData.getColumnTypeName method.