Data Type |
Storage Required |
CHAR(M) |
M × w bytes, 0 <= M <= 255, where w is the number of bytes required for the maximum-length character in the character set. SeeSection 14.5.13.6, “Physical Row Structure” for information about CHARdata type storage requirements for InnoDB tables. |
BINARY(M) |
M bytes, 0 <= M <= 255 |
VARCHAR(M), VARBINARY(M) |
L + 1 bytes if column values require 0 – 255 bytes, L + 2 bytes if values may require more than 255 bytes |
mysql的varchar(N)和int(N)的含义及其与char区别
原文:http://blog.itpub.net/15480802/viewspace-1330966/