当前位置：网站首页>Why is varchar (255) defined in MySQL?

Why is varchar (255) defined in MySQL?

2022-07-22 13:40:00 【sodawoods】

stay 4.0 Version below ,varchar(255) refer to 255 individual byte , Use 1 Bytes Storage length is enough . When it is greater than or equal to 256 when , To use 2 Bytes Storage length . So define varchar(255) Than varchar(256) Better .
But in 5.0 Above version ,varchar(255) refer to 255 individual character , Each character may occupy more than one byte , For example, using UTF8 Each Chinese character occupies 3 byte , Use GBK Each Chinese character accounts for 2 byte .
NOTE： In the production environment, we usually use utf8mb4 Character set .

原网站

版权声明
本文为[sodawoods]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207212317597708.html