ODBC Driver for Oracle

Build 23.0.8839

データ型マッピング

Data Type Mappings

The 本製品 maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.

TYPE_CHAR varchar
TYPE_VARCHAR2 varchar
TYPE_NCHAR varchar
TYPE_NVARCHAR2 varchar
TYPE_CLOB clob
TYPE_NCLOB varchar
TYPE_LONG varchar
TYPE_NUMBER decimal
TYPE_DATE datetime
TYPE_TIMESTAMP datetime
TYPE_TIMESTAMP_WITH_TIMEZONE datetime
TYPE_TIMESTAMP_WITH_LOCAL_TIMEZONE datetime
TYPE_INTERVAL_YEAR_TO_MONTH interval year (year precision) to month
TYPE_INTERVAL_DAY_TO_SECOND interval day (day precision) to second (fractional seconds precision)
TYPE_BLOB binary
TYPE_BFILE binary
TYPE_RAW binary
TYPE_ROWID rowid
TYPE_UROWID urowid
TYPE_BINARY_FLOAT real
TYPE_BINARY_DOUBLE float

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839