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

Most people do not understand the knowledge of this article "what string type is in mysql", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what string type in mysql" article.

Description

1. Both char and varchar are used to save short strings in MySQL. The values in the varchar column are variable length strings.

The main difference between the two lies in the way they are stored: the length of the char column is fixed to the length declared in the creation table. Char removes trailing spaces when retrieving, while varchar does not.

2. Binary and varbinary store binary strings.

When the MySQL value is saved, the specified field definition length is achieved by filling the 0x00 (zero byte) at the end of the value.

Example

-- create table tbc, including fields bc (binary (6)), vbc (varbinary (6)) mysql > create table tbc (bc binary (6), vbc varbinary (6));-- insert data into the table ('a','a') mysql > insert into tbc values ('a','a');-- View field value length mysql > select length (bc), length (vbc) from tbc The above is about the content of this article on "what string types are there in mysql?" I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please 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.