Mobile phone comes with the expression of storage

1 Set Database encoding = UTF8MB4, perfectly compatible with UTF8 format

About UTF8 & UTF8MB4

UTF8 is a character set in Mysql that supports only a maximum of three bytes of UTF-8 characters, which is the basic multi-text plane in Unicode.

To save 4-byte-long UTF-8 characters in Mysql, you need to use the UTF8MB4 character set,

For better compatibility, you should always use UTF8MB4 rather than UTF8. For char type data, UTF8MB4 consumes more space and, according to Mysql's official recommendation, uses VARCHAR instead of char.

2 Setting connection pool initialization execution SQL

Spring.datasource.druid.connection-init-sqls=set names UTF8MB4

Mobile phone comes with the expression of storage