データ型マッピング
データ型マッピング
本製品 は、データソースの型を、スキーマで使用可能な対応するデータ型にマッピングします。以下のテーブルはこれらのマッピングを説明します。
| TINYINT (SIGNED) | tinyint |
| TINYINT (UNSIGNED) | tinyint |
| TINYINT (ZEROFILL) | tinyint |
| BOOLEAN | tinyint |
| INT1 (SIGNED) | tinyint |
| INT1 (UNSIGNED) | tinyint |
| INT1 (ZEROFILL) | tinyint |
| SMALLINT (UNSIGNED) | smallint |
| SMALLINT (UNSIGNED) | smallint |
| SMALLINT (ZEROFILL) | smallint |
| INT2 (UNSIGNED) | smallint |
| INT2 (UNSIGNED) | smallint |
| INT2 (ZEROFILL) | smallint |
| MEDIUMINT (UNSIGNED) | mediumint |
| MEDIUMINT (UNSIGNED) | mediumint |
| MEDIUMINT (ZEROFILL) | mediumint |
| INT3 (UNSIGNED) | mediumint |
| INT3 (UNSIGNED) | mediumint |
| INT3 (ZEROFILL) | mediumint |
| INT (UNSIGNED) | 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 |