SLTechnology News&Howtos › Database ›

Default character set for different versions of MySQL

Shulou Source: shulou.com Published: 2022-06-01 04:46:12 10月03日 Update

MySQL default character set for different versions

MySQL 5.6 Default Character Set

Note: default is utf8, support utf8mb4.

MySQL 5.7 Default Character Set

Note: the default is utf8, to this version of the production environment we will use utf8mb4.

MySQL 8.0 Default Character Set

Note: after a long time, 8.0 finally supports utf8mb4 by default, we will use utf8mb4 in natural production environment.

IV. Summary

1. utf8mb4 is a superset of utf8

2, utf8mb4 support emoji

UTF 8 MB4 can replace UTF 8.

4. Emphasize that in mysql8.0 version, do not use char number type, and use varchar uniformly.