Number of bytes in Chinese characters and letters under MySQL character set

Test under MySQL 5.1.5-alpha to the conclusion

Latin1:

1character=1byte, 1 kanji =2character,

In other words, a field is defined as varchar (200), it can store 100 characters or 200 letters.

This should be noted, especially when the field content is composed of letters and Chinese characters, as far as possible to assume that the field content is composed of Chinese characters, set the field length accordingly

UTF8:

1character=3bytes, 1 Kanji =1character

In other words, a field is defined as varchar (200), it can store 200 characters or 200 letters.

Gbk

1character=2bytes,1 Kanji =1character

In other words, a field is defined as varchar (200), it can store 200 characters or 200 letters.

Number of bytes in Chinese characters and letters under MySQL character set