Mysql, emoji, and special characters, mysqlemoji

Mysql, emoji, and special characters, mysqlemoji

Since login is a very common login method, relevance should also be considered during database design. Generally, it is enough to store open_id, icons, and nicknames. Special attention should be paid to the nickname, otherwise it may be like this:

Mysql: 1366 Incorrect string value ......

This is because nicknames use special characters, such as the UNICODE emoji extension zone. Mysql utf8 default cannot be stored, and the number of digits is insufficient. Reference: link 1

The corresponding field should be modified to utf8mb4, and the parameters of the stored procedure should also be modified (link 2 ):

Create procedure 'emoji' (text varchar (20) CHARSET utf8mb4) begin select text; END

 

To test this problem, you can use:

Select unhex ('f09f8d83 ')

Or

INSERT tb ('text') VALUES (unhex ('f09f8d83 '))

 

 

Link 1: http://www.cnblogs.com/lampbrotherIT/p/5794742.html

Link 2: https://stackoverflow.com/questions/17650662/creating-a-stored-procedure-with-utf8-strings