Those things about MySQL (4) Selection of building table coding

MySQL build database or build a table will encounter the problem of choice coding, we used to be a habitual choice utf8, but in MySQL after 5.5.3 version with UTF8MB4 encoding, UTF8MB4 can save 4 bytes Unicode,mb4 is most bytes 4 of the meaning. Including emoji expressions and a lot of infrequently used Chinese characters can be stored, but also can store any new Unicode characters, extensibility good ah.

The maximum character length of the UTF8 encoding is 3 bytes, and if it encounters a 4-byte paragraph, it will be a moth.

Also, UTF8MB4 is a superset of UTF8, except that it does not require other conversions to change the encoding to UTF8MB4.

Of course, you have to be frugal, then continue to use UTF8 Bar, save space.

So the conclusion is: MySQL build database to build table please use UTF8MB4.

Ps:emoji Emoticons are a special Unicode encoding that is used on IOS and Android phones and mobile devices.

Those things about MySQL (4) Selection of building table coding