数値範囲 | mysql | java | golang | javascript |
---|---|---|---|---|
-128 ~ 127 | tinyint | byte | int8 | - |
-32768 ~ 32767 | smallint | short | int16 | - |
-8388608 ~ 8388607 | mediumint | (int) | (int32) | - |
-2147483648 ~ 2147483647 | int | int | int32 | - |
-9223372036854775808 ~ 9223372036854775807 | bigint | long | int64 | ○ |
※カッコは補うためのタイプ
数値範囲 | mysql | java | golang | javascript |
---|---|---|---|---|
0 ~ 255 | tinyint | (short) | uint8 | - |
0 ~ 65535 | smallint | (int) | uint16 | - |
0 ~ 16777215 | mediumint | (int) | (uint32) | - |
0 ~ 4294967295 | int | (long) | uint32 | - |
0 ~ 18446744073709551615 | bigint | java.math.BigInteger | uint64 | - |
※カッコは補うためのタイプ
範囲 | mysql | java | golang | javascript |
---|---|---|---|---|
32bit | float | float | float32 | - |
64bit | double | double | float64 | ○ |