ADO.NET Provider for MariaDB

Build 24.0.9062

データ型マッピング

データ型マッピング

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

TINYINT (SIGNED) tinyint
TINYINT (UNSIGNED) tinyint
TINYINT (ZEROFILL) tinyint
BOOLEAN tinyint
INT1 (SIGNED) tinyint
INT1 (UNSIGNED) tinyint
INT1 (ZEROFILL) tinyint
SMALLINT (SIGNED) smallint
SMALLINT (UNSIGNED) smallint
SMALLINT (ZEROFILL) smallint
INT2 (SIGNED) smallint
INT2 (UNSIGNED) smallint
INT2 (ZEROFILL) smallint
MEDIUMINT (SIGNED) mediumint
MEDIUMINT (UNSIGNED) mediumint
MEDIUMINT (ZEROFILL) mediumint
INT3 (SIGNED) mediumint
INT3 (UNSIGNED) mediumint
INT3 (ZEROFILL) mediumint
INT (SIGNED) int
INT (UNSIGNED) int
INT (ZEROFILL) int
INT4 (SIGNED) int
INT4 (UNSIGNED) int
INT4 (ZEROFILL) int
BIGINT (SIGNED) bigint
BIGINT (UNSIGNED) bigint
BIGINT (ZEROFILL) bigint
INT8 (SIGNED) bigint
INT8 (UNSIGNED) bigint
INT8 (ZEROFILL) bigint
DECIMAL (SIGNED) decimal
DECIMAL (UNSIGNED) decimal
DECIMAL (ZEROFILL) decimal
FLOAT (SIGNED) real
FLOAT (UNSIGNED) real
FLOAT (ZEROFILL) real
DOUBLE (SIGNED) float
DOUBLE (UNSIGNED) float
DOUBLE (ZEROFILL) float
BIT bit
BINARY binary
BLOB blob
TINYBLOB tinyblob
MEDIUMBLOB mediumblob
LONGBLOB longblob
TINYTEXT tinytext
TEXT text
MEDIUMTEXT mediumtext
LONGTEXT longtext
CHAR char
ENUM enum
LONG mediumtext
LONGVARCHAR mediumtext
CHARBYTE binary
VARBINARY binary
VARCHAR varchar
SET set
DATE date
TIME time
DATETIME datetime
TIMESTAMP datetime
YEAR year
POINT point
LINESTRING linestring
POLYGON polygon
MULTIPOINT multipoint
MULTILINESTRING multilinestring
MULTIPOLYGON multipolygon
GEOMETRYCOLLECTION geometrycollection
GEOMETRY geometry

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