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