Emoji expression needs to use the encoding format is not utf8mb4,mysql database version to more than 5.5, I use 5.6, because only 5.5 or more support UTF8MB4.1. The database encoding is set to UTF8MB4, if you specify UTF8 when you build the library, you need to execute the statement: ALTER database database_name CHARACTER set = UTF8MB4 COLLATE = Utf8mb4_unicode_ Ci2. At the same time specify the database configuration parameters character_set_server c
If the UTF8 character set is a Java server, when the store contains a emoji expression, it throws an exception similar to the following:Java.sql.SQLException:IncorrectStringValue' \xf0\x9f\x92\x94 'For column' Name ' at row1 at Com.mysql.jdbc.SQLError.createSQLException (Sqlerror.java:1073) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:3593" at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java: 3525) at Com.mysql.jdbc.MysqlIO.se
The recently developed iOS project, because of the need for user text storage, naturally encountered an issue where emoticons such as emoji were supported by MySQL DB. Troubled for a few days, on the verge of desperate abandonment, finally completed the conversion and migration. In this special analysis and collation, convenient for more people. Problem Description: java.sql.sqlexception:incorrectstringvalue: ' \xf0\x9f\x92\x94 ' forcolumn ' name '
Label:http://www.v2ex.com/t/137724 If you want your website or App to support Emoji, there are some details you need to know when setting up MySQL for the first time.EmojiThe special point of the Emoji character is that it takes 4 bytes to store it. This collate of the UTF8 character set, which is common in MySQL, utf8_general_ci supports only 3 bytes. So to be able to store
1. SVG Overview:
SVG (Scalable Vector Graphics, Scalable Vector Graphics) is W
3c
An open standard text-style vector graphic description language, which is an XML-based image format specially designed for the network. SVG is a language that uses XML to describe two-dimensional graphics. SVG graphics can be dynam
Tags: des style blog HTTP Io OS ar Java1. Introduction to SVG
-----------------------------------------------------------------
SVG is a vector image format unrelated to image resolution. It uses strict XML syntax to describe the image content. With regard to it, the host at the Massachusetts Institute of Technology's W3C official site has a comprehensive introduction (http://www.w3.org/Graphics/
Emoji is a one-character set developed by Japanese (do not buy Japanese products, support Chinese products, hate Japanese men, haha) and is integrated into IOS. You can activate emoji by programming.
First, determine whether emoji is supported:
- (BOOL)supportEmoji{BOOL hasEmoji = NO;#define kPreferencesPlistPath @"/private/var/mobile/Library/Preferences/com.app
The problem is that there is a database with many tables and a lot of existing data. most of the data is stored in utf8 (incomplete, and latin1 ). The storage fails due to the user's emoji storage. it is known that utf8mb4 is required for proper storage. The problem with mysql... is as follows:
There is a database with many tables and a lot of existing data. most of the data is stored in utf8 (not all, and latin1 ).
The storage fails due to the user's
Push content If it contains a emoji expression, you need to make the following changes
1 MySQL to use 5.5.3 or more (if not upgrade, please save with Base64, push and then Transcode)
2 Modify the table and push content field to the UTF8MB4_UNICODE_CI encoding format (no need to change the system's MY.CNF, do not need to restart MySQL)
If you use apnsphp to push, there may still be problems sending emoji em
In the Office based Communication software, commonly used in some emoji chat version, found in MySQL can not be stored.
Because the emoji expression is converted into four bytes (\XF0\X9F\X90\XAC) at the time of storage;Because the database uses the UTF8 character set utf8_general_ci, this collation rule (collation) supports only 3 bytes, so four bytes of emoji
For you to touch the Treasure Input method software users to detailed analysis to share the use of emoji expression of the tutorial.
Tutorial Sharing:
Method One:
In the touch of the treasure input method under the "Space" button can be called emoji expression.
Method Two:
1, click on the "symbol" at the touch point input method;
2, choose "Facial expression";
3, you can choos
Tags: BSP app flow mysql5.5 convert emoji character set settings own clientI. Problems and CausesThe app wanted to support emoji, but found that the MySQL database was unable to write emoticons. The reason is that our MySQL database is UTF8 encoded by default, the UTF8 encoding is stored with three bytes, but the emoji expression is 4 bytes, resulting in a data i
Go to SVG and go to xiuxian.
What is SVG? Many people may have heard about SVG, but they do not necessarily know what SVG is: SVG (a string of Scalable Vector Graphics that cannot be understood in English) Scalable Vector Graphics, it defines vector-based images for the netw
Let MySQL support Emoji expressions. We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connections. What is the difference between utf8mb4 and utf8? Previous
Let MySQL support Emoji expressions. We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connections. What is the difference between utf8mb4 and utf8?
Enable MySQL 5.6 to support Emoji expressions
Let MySQL support Emoji expressions. We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connections.
MySQL 5.6
1 solution: Convert Mysql encoding from utf8 to utf8mb4.
Required> = MySQL 5.5.3 and slave database must also be 5.5. Earlier versions do not support this character set or duplicate error.
2 Add the my.
Tags: User Client SQ byte theory ase nbsp Problem collateMySQL added this UTF8MB4 code after version 5.5.3, Mb4 is the most bytes 4 meaning, specifically for compatibility with four-byte Unicode. In fact, UTF8MB4 is a superset of UTF8, theoretically using UTF8, and then modifying the character set to UTF8MB4, will not have any problems with the existing UTF8 encoded reads. Small program of the project, found to save the user information nickname times wrong, looking for reasons to find that some
Tags: mysql problem special character icon Lam value div with timingSince the landing was already very popular in the way of landing, the relevance should also be considered in database design. General storage open_id, icons, nicknames is enough. The nickname should be special attention, otherwise it might be like this: mysql:1366 incorrect string value bar bar ... This is because the nickname uses special characters, such as the Unicode emoji extensi
let MySQL support emoji emoticons, involving wireless-related MySQL database recommendations are in advance with the UTF8MB4 character set. MySQL version 5.61 solution: Convert the MySQL encoding from UTF8 to UTF8MB4.Requires >= MySQL 5.5.3 version, from the library must be 5.5, the lower version does not support this character set, copy error2 my.cnf File added [Mysqld]character-set-server = Utf8mb4collation-server = Utf8mb4_unicode_ciinit_connect= '
21,003 Chinese characters, GB2312 extension.
Utf-8:unicode standard variable length character encoding, Unicode Standard (Uniform code), industry uniform standards, including the world's dozens of kinds of text system;
UTF-8: Encode each character using one to three bytes.
Utf8mb4: Stores four bytes, and the application is used to store emoji emoticons because it can have emoji four bytes of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.