Bildergalerie +++ Ereignisse +++ Spiele +++ Tipps & Tricks

TINYINT small integer
 –128 to 127 or 0 to 255.
 
SMALLINT small integer
 –32768 to 32767 or 0 to 65535
 
MEDIUMINT medium-size integer
 –8388608 to 8388607 or 0 to 16777215
 
INTEGER normal-size integer
 –2147483648 to 2147483647 or 0 to 4294967295
 
BIGINT large integer
 –9223372036854775808 to 9223372036854775807 or 0 - 18446744073709551615
 
FLOAT small
 –3.402823466E+38 to –1.175494351E-38, 0 and 1.175494351E-38 to 3.402823466E+38
 
DOUBLE, DOUBLE PRECISION, REAL
 -1.7976931348623157E+308 to -2.2250738585072014E-308, 0 and 2.2250738585072014E-308 to 1.7976931348623157E+308
 
CHAR  length 1 to 255 characters

VARCHAR  length 1 bis 255 characters

TINYBLOB, TINYTEXT  length of 255 (2^8 - 1)

BLOB, TEXT  length of 65535 (2^16 - 1)

MEDIUMBLOB, MEDIUMTEXT length of 16777215 (2^24 - 1)

LONGBLOB, LONGTEXT length of 4294967295 (2^32 - 1)