Shulou(Shulou.com)06/01 Report--

This article mainly introduces what MySQL string types are. It is very detailed and has certain reference value. Friends who are interested must finish reading it.

MySQL string type

In the MySQL database, there is no concept of strings, only characters, so the database uses only single quotation marks.

Char (4): store 4 characters, both in Chinese and English.

Varchar (L): implement the variable length mechanism, which requires additional space to record the true length of the data.

The theoretical length of L is 65535, but in fact it cannot be reached. Because some characters are multi-byte characters, L is less than 65535.

Utf8 1 character = 3 bytes

Gbk 1 character = 2 byt

Note:

The total length of all fields of a record (excluding big data) cannot exceed 65535

The type of the text series stores the address in the table and occupies 10 bytes

The above is all the content of the article "what are the MySQL string types?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.