ODBC Driver for MySQL

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.

INT int
VARCHAR() varchar
DECIMAL() decimal
DATETIME datetime
BLOB blob
BINARY() binary
BLOB() tinyblob
LONGBLOB longblob
MEDIUMBLOB mediumblob
TINYBLOB tinyblob
VARBINARY() binary
DATE date
DATETIME() datetime
TIME time
TIMESTAMP() datetime
YEAR() year
GEOMETRY geometry
GEOMETRYCOLLECTION geomcollection
LINESTRING linestring
MULTILINESTRING multilinestring
MULTIPOINT multipoint
MULTIPOLYGON multipolygon
POINT point
POLYGON polygon
BIGINT() bigint
DECIMAL decimal
DOUBLE float
FLOAT real
INT() int
MEDIUMINT() mediumint
REAL float
SMALLINT() smallint
TINYINT() tinyint
CHAR() char
JSON json
NCHAR() char
NVARCHAR() varchar
VARCHAR() varchar
BIT() bit
BOOLEAN tinyint
LONGTEXT longtext
MEDIUMTEXT mediumtext
TEXT() tinytext
TINYTEXT tinytext
ENUM enum
SET set

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