JDBC Driver for Teradata

Build 24.0.9062

データ型マッピング

データ型のマッピング

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

ARRAY SYSUDTLIB.MyArrayName
BYTE BYTE
BLOB BLOB
CHAR CHAR
DATASET DATASET STORAGE FORMAT AVRO
DATE DATE
TIME TIME
TIMESTAMP TIMESTAMP
TIME WITH TIME ZONE TIME WITH TIME ZONE
TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE
ST_Geometry SYSUDTLIB.ST_GEOMETRY
MBR SYSUDTLIB.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 FLOAT
REAL FLOAT
DOUBLE PRECISION FLOAT
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