Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the difference between char and varchar in mysql", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's make up a small series to take you to learn "what is the difference between char and varchar in mysql"!

Difference: 1, char field maximum length of 255 characters, varchar field maximum length of 65535 bytes;2, char type in the use of space will be wasted, and varchar type in the use of space is more economical;3, char type search efficiency is high, varchar type search efficiency is relatively low.

Operating environment of this tutorial: Windows 7 system, MySQL8 version, Dell G3 computer.

Difference between char and varchar

behavior char field varchar field maximum length 255 characters 65535 bytes, so the maximum number of characters in parentheses must be coded to be negative length fixed length, insufficient part with hidden spaces filled in variable length space use will be wasteful more efficient to find high and low tail spaces omitted insertion will not omit insertion, search will omit like in the search statement after the like will not save the sentence after the like will not save, the space at the end of the field will not save this I believe that everyone has a deeper understanding of "what is the difference between char and varchar in mysql", so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.