The Advanced SQL Engine has 3 Geospatial data types:
SQL Data Type | Description |
---|---|
ST_Geometry | Represents any of the following geometry types: ST_Point, ST_LineString, ST_Polygon, ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, ST_MultiPolygon and GeoSequence. |
MBR | Providers a way to obtain the minimum bounding rectangle (MBR) of a geometry for tessellation purposes. |
MBB | Providers a way to obtain the minimum bounding box (MBB) of a geometry. |
The "SQL Geospatial Types" manual describes each type in detail. This sections shows how the SQL Geospatial types map to the .NET type system.
The SQL Engine transforms ST_Geometry, MBR, MBB data types to CLOB, VarChar(256) and VarChar(340) respectively. CLOB and VarChar data types are mapped to the following Base Class Library (BCL) types:
The .NET Data Provider for Teradata converts the SQL Geospatial types to the BCL types and/or TdClob Provider Specific Types:
SQL Type | BCL Type | Provider Specific Type |
---|---|---|
MBR, MBB | System.Char[] | NA |
System.String | ||
ST_Geometry | System.Char[] | TdClob |
System.String |