To accommodate importing and exporting geospatial data from and to other types and formats, Vantage provides other transform groups for the ST_Geometry type.
- To override the default CLOB/WKT transform for geospatial data for the current session, use the SET TRANSFORM GROUP FOR TYPE statement.
- To override the default CLOB/WKT transform for geospatial data for a particular user or profile, specify the transform to use in the CREATE/MODIFY USER and CREATE/MODIFY PROFILE statements.
The following table lists the transform groups that are available for the ST_Geometry type.
| Transform Group | Import/Export Type | Default | Format |
|---|---|---|---|
| ST_WellKnownText | CLOB (Latin character set) |
Yes | WKT This corresponds to the ST_GEOMETRY_IO transform group in previous database releases. |
| ST_WellKnownBinary | BLOB | No | Well-known binary (WKB) |
| TD_GEO_VARCHAR | VARCHAR(64000) (Latin character set) |
No | WKT |
| TD_GEO_VARBYTE | VARBYTE(64000) | No | WKB |
| ST_WellKnownTextSRID | CLOB (Latin character set) |
No | Extended WKT (WKT and SRID) |
| ST_WellKnownBinarySRID | BLOB | No | Extended WKB (WKB and SRID) |
| TD_GEO_VARCHAR_SRID | VARCHAR(64000) (Latin character set) |
No | Extended WKT |
| TD_GEO_VARBYTE_SRID | VARBYTE(64000) | No | Extended WKB |
For more information on the WKT, WKB, and extended formats, see Geospatial Data Formats.