Pitney-bowes MapInfo Professional Uživatelský manuál Strana 176

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 540
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 175
Oracle Data Support
Working with Oracle Spatial Data
MapInfo Professional uses Oracle Spatial for Oracle tables (XY is supported via OCI). MapInfo
Professional does not support HH_CODE (and the old version of SDO index types).
Supported Oracle Data Types
The following lists non-spatial data types from Oracle Spatial and what they are treated as in MapInfo
Professional:
to MapInfo ProfessionalFrom Oracle
BinaryString up to 127 bytes shown as Hex
characters
RAW, LONG RAW
MIObjectNamed type
MIObjectNamed Object type (SDO_GEOM)
Not SupportedBLOB, CLOB
CharacterCHAR, VARCHAR, LONG, LONG VARCHAR
if no scale or precision: Float else DecimalNumber, Decimal
IntegerINTEGER
FloatFLOAT
DateDATE
MapInfo Professional captures many Oracle data types and translates them into MapInfo native types.
When the column is updated, Oracle data makes sure that the data being bound is translated into the
column format (for example, MapInfo Professional can bind a character as a long and send it through
to Oracle and on the other end it will be translated into a long number in the table).
Spatial Object Types from Oracle Spatial to MapInfo Professional
to MapInfo ProfessionalFrom Oracle: GTYPES
NULL0 UNKNOWN_GEOMETRY (Spatial ignores this
geometry.)
Point1 POINT Geometry contains one point.
Line (if only 2 pts) or Polyline if > 2 pts)2 LINESTRING Geometry contains one line string.
Region3 POLYGON Geometry contains one polygon.
Collection4 Collection Geometry is a heterogeneous
collection of elements.
MultiPoint5 MULTIPOINT Geometry has multiple points.
Region6 MULTILINESTRING Geometry has multiple line
strings. Poly-line
MapInfo Professional 12.5176
About Supported DBMS Data Types
Zobrazit stránku 175
1 2 ... 171 172 173 174 175 176 177 178 179 180 181 ... 539 540

Komentáře k této Příručce

Žádné komentáře