The problem, because the UTF-8 encoding could be two, three, four bytes. Emoji emoticons or some special characters are 4 bytes, and MySQL UTF8 encode up to 3 bytes, so data is not plugged in.That's my solution.1. Locate the My.ini in the MySQL installation directory and make the following changes:[Mysqld]Character-set-server=utf8mb4[MySQL]Default-character-set=utf8mb4Restart MySQL after modification2. Convert the already built tables to UTF8MB4Comman
Tags: coded har var ODI url nic variables amp characterBackground:Because of the need to implement emoji expression comment function, so the database needs to support emoji expression storageMySQL UTF8 encodes a character up to 3 bytes, but a emoji expression is 4 bytes, so UTF8 does not support storing emoji emoticons. But UTF8 's superset utf8mb4 a character can have up to 4 bytes, so it can support the storage of emoji expression. However, UTF8MB4
Let MySQL support emoji emoticons, involving wireless-related MySQL database recommendations are in advance with the UTF8MB4 character set.What's the difference between utf8mb4 and UTF8? The original MySQL UTF8 a character up to 3 bytes, while the UTF8MB4 expands to a character up to 4 bytes, so it can support more character sets.Solution: Convert the MySQL encoding from UTF8 to UTF8MB4.Requires >= MySQL 5.5.3 version, from the library must be 5.5, th
Can be used in controls such as iOS Uilabel,uitextview,uialertviewUse the following methodNSString *s = [NSString stringwithformat:@ "This was a smiley \ue415%c face", 0xe05a]; NSLog (@ "one----%@", s); Label.text=s; The following are the corresponding emoticons, but the code in the new SDK has changed, please refer to the official Apple document against the http://opensource.apple.com/source/ICU/ICU-461.13/icuSources/data/ Translit/any_softbanksms
start_urls start entrance is defined as follows, crawling 1 to 20 pages of image emoticons. To download more emoticons pages you can add more.
Start_urls = [' https://www.doutula.com/photo/list/?page={} '. Format (i) for I in range (1, 20)]
2. Enter the developer Mode Analysis page structure, you can see the following structure. Right-click to copy the XPath address to get the full expression of the a tag
Recently, due to project requirements, you need to enter QQ expressions in the text box where you leave a message. This effect is already very common, next, I will share a QQ emoticons plug-in that I found on the Internet using jquery.
First, let's take a look at the QQ emoticons plug-in!
The following is the specific implementation code (only the code is pasted here, and the complete download package addr
Some methods have been modified. The expression is read directly from the directory. So now you can easily increase or decrease the image of the expression. Just put the picture in the face directory. However, the Chinese image name is not supported at the moment.
/*Modify1. The face directory can be arbitrarily increased or decreased the expression picture (Chinese is not currently supported)2. Default support JPG, JPEG, PNG, emoji image with GIF format
Description: Comment
resource file, in the file path to create an array, the data stored in the array is the file content code is as follows: Load the data in the plist file nsbundle *bundle = [NSBundle mainbundle]; Find the path to the resource nsstring *path = [Bundle pathforresource:@ "Emoticons" oftype:@ "plist"]; Get data in plist nsarray *face = [[Nsarray alloc] initwithcontentsoffile:path];3. Generate our test string, the last one is not any expr
MySQL store emoji emoticons to use the UTF8MB4 character set, which is 4 bytes of storage, the minimum supported version is 5.5.3+, if not, upgrade to a newer version.Modify the MySQL configuration fileWindow directory: mysql/my.iniubuntu16.04 directory:/ETC/MYSQL/CONF.D/MYSQL.CNF configuration client/etc/mysql/mysql.conf.d/mysql.cnf Configure server Other directories: generally in ETC/MYSQL/MY.CNFAdd the following three parts to the MySQL configurati
Tags: mysqlRecently in the data migration, there was a field of type Clob, after the migrated field type of Varchar,blob converted to string data, found that there is a emoji expression exists, resulting in data migration failure. The reason for the failure is that the Utf-8 type set in the MySQL database is 3 bytes, and the emoji expression Utf-8 is 4 bytes, so it cannot be passed in.To enable MySQL to store emoji emoticons, you need a database versi
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= '
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 '
Now, windows10/windows8.1pc version of the WhatsApp communication applications ushered in the update, added voice call function, across the application sharing video, pictures and link functions, the application of the photo-sharing function, a one-time share of multiple photos and video features. Updated to v 0.2.2234 version. It is not only a Web page version of the WhatsApp package, but also support WINDOWS10 Notification Center, as well as file sending and camera calls. Note that this versio
How do I bulk import and export emoticons tutorials in the PP helper:
After the computer installed the master of the PP expression management, the iOS device connected to the computer, select "Import expression" can be the local expression of a button import, drag and drop sync to the phone WeChat, support GIF, JPG, PNG, BMP, TIFF and many other expression image format, the operation is very simple.
WeChat collection of personalized expression can
When you are playing a beautiful shoot, you will find that the United States shot more than the expression plus voice or subtitles new features! That's right! This is the new play recommended by the United States photography, new emoji Oh! You can add emoji or voice to your photos, super new gameplay, this article will bring you a tutorial, let everyone easy to play.
Mei shot the latest feature of the expression text, this is in the picture above the new gameplay and not the United States s
]default-character-set=utf8mb4
Change the character set of the datebase,table,column (in fact I only use the next two, the datavase does not change and does not seem to affect):# foreachDatabase:ALTER DATABASEdatabase_nameCHARACTER SET =UTF8MB4 COLLATE=utf8mb4_unicode_ci;# foreachTable:ALTER TABLEtable_nameCONVERT to CHARACTER SETutf8mb4 COLLATE utf8mb4_unicode_ci;# foreachcolumn:ALTER TABLETABLE_NAME Change COLUMN_NAME column_nameVARCHAR(191)CHARACTER SETUTF8MB4 COLLATE utf8mb4_unicode_ci;
not be able to use UTF8MB4Finally, let the front-end application insert emoji expression, you can.Some small knowledge pointswhere Character-set-server and collation-server these settings for the UTF8MB4 character set is relatively easy to understand, that is, the MySQL database related to the character sets are set to UTF8MB4;However, in order to implement the client UTF8 connection to MySQL, the use of the UTF8MB4 character set, the Mysqld configuration is configured in the init_connect= ' se
CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;For each of the tables:
ALTER table here is the table name CONVERT to CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
3. Modify the MySQL configuration file
Go to this directory, under this directory there is a suffix .cnf filecd/usr/local/mysql/support-files/
Copy this file to the etc directory and name my.cnf itsudo cp my-default.cnf/etc/my.cnf
Then edit the my.cnf file and copy the contents below.
[Client]Def
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.