CHAR(M)为固定长度的字符串,M取值0~255个字符, VARCHAR(M)是变长字符串,实际长度由字符数决定,需要多一个字节存储字符的数量
字符串 | CHAR(4) | 存储需求 | VARCHAR(4) | 存储需求 |
‘’ | ‘ ‘ | 4字节 | ‘’ | 1字节 |
‘ab’ | ‘ab ‘ | 4字节 | ‘ab’ | 3字节 |
‘abc’ | ‘abc ‘ | 4字节 | ‘abc’ | 4字节 |
‘abcd’ | ‘abcd’ | 4字节 | ‘abcd’ | 5字节 |
‘abcdef’ | ‘abcd’ | 4字节 | ‘abcd’ | 5字节 |