mysql utf8mb4

Original: http://blog.csdn.net/woslx/article/details/49685111The UTF-8 encoding may be 2 bytes, 3 bytes, 4 bytes of characters, but the UTF8 encoding of MySQL only supports 3 bytes of data, and the expression data on the mobile side is a 4-byte

Mycat (3) temporarily solves the utf8mb4 encoding problem1. About utf8mb4 Utf8mb4 is a superset of utf8Utf8mb4 is compatible with utf8 and can represent more characters than utf8.Emoji is an emoticon. Its meaning comes from Japanese (Japanese)Emojis

I solved the problem with his method, the pro-test is available, do not use Navicat for MySQL to query the code,Enter MySQL in the server with the root command and show variables like ' char% '; the encoding of the command query is the most accurate.

This text connection: http://blog.csdn.net/freewebsys/article/details/45537411 reprint Please specify the source!1, about UTF8MB4UTF8MB4 is a superset of UTF8UTF8MB4 is compatible with UTF8 and can represent more characters than UTF8.Emoji is an

Mycat (3) temporarily solves the utf8mb4 encoding problem, mycatutf8mb4 The original Article connection: http://blog.csdn.net/freewebsys/article/details/45537411 reproduced please indicate the source!1. About utf8mb4 Utf8mb4 is a superset of

(I) Preface In order to cope with opportunities and challenges of the wireless Internet, and to avoid problems caused by emoji, We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connection. This

(I) Preface In order to cope with opportunities and challenges of the wireless Internet, and to avoid problems caused by emoji, We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connection. This

Utf8mb4 is currently the largest character encoding and supports any text.Why is there UTF8MB4?Since utf8 has no problem in daily use, why utf8mb4? MySQL of earlier versions supports UTF-8 encoding. The maximum character length is 3 bytes. If a

GarbledWe recommend that you take a closer look at MySQL character set settings to distinguish between client and server encoding. The simplest and most violent method is to explicitly specify the same encoding in all links.For example, when using

MySQL sets utf8mb4 encoding. there is a project that needs to store ios expressions (emoji expressions) Although this type of expression is UTF-8 encoded, a single character occupies 4 bytes, while MySQL utf8 encoding can only store 3 bytes of