ADO.NET Provider for Teradata

Build 24.0.9062

データ型マッピング

データ型のマッピング

本製品 は、データソースの型を、スキーマで使用可能な対応するデータ型にマッピングします。以下のテーブルはこれらのマッピングを説明します。

ARRAY MyArrayName
BYTE BYTE
BLOB BLOB
CHAR CHAR
DATASET DATASET
DATE date
TIME time
TIMESTAMP datetime
TIME WITH TIME ZONE TIME WITH TIME ZONE
TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE
ST_Geometry ST_GEOMETRY
MBR MBR
INTERVAL YEAR INTERVAL YEAR
INTERVAL YEAR TO MONTH INTERVAL YEAR TO MONTH
INTERVAL MONTH INTERVAL MONTH
INTERVAL DAY INTERVAL DAY
INTERVAL DAY TO HOUR INTERVAL DAY TO HOUR
INTERVAL DAY TO MINUTE INTERVAL DAY TO MINUTE
INTERVAL DAY TO SECOND INTERVAL DAY TO SECOND
INTERVAL HOUR INTERVAL HOUR
INTERVAL HOUR TO MINUTE INTERVAL HOUR TO MINUTE
INTERVAL HOUR TO SECOND INTERVAL HOUR TO SECOND
INTERVAL MINUTE INTERVAL MINUTE
INTERVAL MINUTE TO SECOND INTERVAL MINUTE TO SECOND
INTERVAL SECOND INTERVAL SECOND
JSON JSON
BYTEINT BYTEINT
SMALLINT SMALLINT
INTEGER int
BIGINT bigint
DECIMAL decimal
NUMERIC decimal
FLOAT DOUBLE PRECISION
REAL DOUBLE PRECISION
DOUBLE PRECISION DOUBLE PRECISION
NUMBER NUMBER
PERIOD(DATE) PERIOD DATE
PERIOD(TIME) PERIOD TIME
XML XML

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