What is the difference between varchar and char?

Difference one , Set and lengthen
char It means fixed length , Fixed length ,varchar It means longer , I.e. variable length .char If the inserted length is less than the defined length , Fill with spaces ;varchar Less than the defined length , It is still stored according to the actual length , Save as long as you insert .

Because its length is fixed ,char The access speed is still faster than varchar It's much faster , Convenient program storage and search ; however char It's also the price of space , Because its length is fixed , So it takes up extra space , It can be said that space in exchange for time efficiency .varchar On the contrary , Time for space .

The second difference , Different storage capacity
Yes char Come on , The maximum number of characters that can be stored 255, It's not about coding .
and varchar Well , Can store at most 65532 Characters .varchar The maximum effective length of is determined by the maximum line size and the character set used . The overall maximum length is 65,532 byte .
————————————————
Copyright notice ： This paper is about CSDN Blogger 「 Slow ugly duckling 」 The original article of , follow CC 4.0 BY-SA Copyright agreement , For reprint, please attach the original source link and this statement .
Link to the original text ：https://blog.csdn.net/qq_20264581/article/details/83755789