MySQLへJAVAからアクセスする場合のIntergerデータ型対応の表。
MySQLのIntegerデータ型を格納できるJAVAのデータ型を掲載する。
| MySQL Type | Bytes | Min | Max | Java Type | Min | Max |
|---|---|---|---|---|---|---|
| TINYINT | 1 | -128 (-2^7) | 127 (2^7-1) | Byte | -128 (-2^7) | 127 (2^7-1) |
| SMALLINT | 2 | -32,768 (-2^15) | 32,767 (2^15-1) | Short | -32,768 (-2^15) | 32,767 (2^15-1) |
| MEDIUMINT | 3 | -8,388,608 (-2^23) | 8,388,607 (2^23-1) | Integer | -2,147,483,648 (-2^31) | 2,147,483,647 (2^31-1) |
| INT | 4 | -2,147,483,648 (-2^31) | 2,147,483,647 (2^31-1) | Integer | 〃 | 〃 |
| BIGINT | 8 | -9,223,372,036,854,775,808 (-2^63) | 9,223,372,036,854,775,807 (2^63-1) | Long | -9,223,372,036,854,775,808 (-2^63) | 9,223,372,036,854,775,807 (2^63-1) |
| UNSINGED TINYINT |
1 | 0 | 255 (2^8-1) | Short | -32,768 (-2^15) | 32,767 (2^15-1) |
| UNSINGED SMALLINT |
2 | 0 | 65,535 (2^16-1) | Integer | -2,147,483,648 (-2^31) | 2,147,483,647 (2^31-1) |
| UNSINGED MEDIUMINT |
3 | 0 | 16,777,215 (2^24-1) | Integer | 〃 | 〃 |
| UNSINGED INT |
4 | 0 | 4,294,967,295 (2^32-1) | Long | -9,223,372,036,854,775,808 (-2^63) | 9,223,372,036,854,775,807 (2^63-1) |
| UNSINGED BIGINT |
8 | 0 | 18,446,744,073,709,551,615 (2^64-1) | BigInteger |