This article mainly describes the MySQL character set. Are you interested in the practical application of the MySQL character set? If you are interested in the practical application of the MySQL character set. You can use the following articles to understand the details.
Test MySQL 5.1.5-alpha and draw the following conclusion:
Latin1:
1 character = 1 byte, 1 Chinese character = 2 character,
That is to say, if a field is defined as varchar (200), it can store 100 Chinese characters or 200 letters.
Utf8:
1 character = 3 bytes, 1 Chinese character = 1 character
That is to say, if a field is defined as varchar (200), it can store 200 Chinese characters or 200 letters.
Gbk:
1 character = 2 bytes, 1 Chinese character = 1 character
That is to say, if a field is defined as varchar (200), it can store 200 Chinese characters or 200 letters.
The above content is an introduction to the MySQL character set. I hope you will have some gains.
The above content is an introduction to the MySQL character set. I hope you will get something better.