facepalm emoji

Convert emoji to UTF8 and store to database, but inefficient1 Public functionRrr$text) {2 $text= ' A?? Ss?? Ss?? ss;3 //emoji symbols for handling names4 $tmpStr= Json_encode ($text);//exposing the Unicode5 6 $TMPSTR 1=Preg_replace_callback("# (\\\ue[0-9a-f]{3}) #i",function($a) {7 //var_dump ($a);8 return addslashes($a[1]);9 //return $a;T

Tags: http color ingest scene href character type data sdn1. First introduce the following commonly used character sets ASCII: United States Information Interchange standard coding; English and other Western European languages; single-byte encoding, 7-bit represents a character, a total of 128 characters. GBK: Double-byte, Chinese character code expansion specification; Chinese, Japanese and Korean characters, English, numerals, double-byte encoding, a total of 21,003 Chinese charac

MySQL does not show emoji expression or display?? , the reason is not explained here, directly to say the solution. (mainly modified UTF8MB4)1. Modify the table2. Modifying fieldsALTER TABLE ' table_name ' MODIFY COLUMN ' column_name ' varchar CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;3. CharSet when modifying client connectionsExample: In thinkphp, when you configure a link database parameter, ' db_charset ' = ' utf8mb4 'Do here, basically al

Why do you want to set the database charset to UTF8MB4? UTF8 used to be all the time? The answer is here: UTF8 for Internet interactions that do not use mobile devices, UTF8MB4 is suitable for the current mobile device Internet development, as mobile devices often have emoji (emoji) storage, which consumes 4 bytes of storage space, while UTF8 is 3 bytes, so that With 3 bytes to store 4 bytes of things, it i

Label:At first, the following phenomena were found: mysql>showvariableslike ' character% '; +--------------------------+---------------------------------------+ |variable_name |Value | +--------------------------+---------------------------------------+ |character_set_client |latin1 | |character_set_connection|latin1 | |character_set_database|latin1 | |character_set_filesystem|binary | |character_set_results |latin1 | |character_set_server|utf8mb4 | |character_set_system|utf8 | |characte

http://my.oschina.net/jiemachina/blog/189460Note that the replacement of these emoji is the standard expression characters, each expression is originally 2 bytes, replaced by a string, each expression becomes 12 characters, wasted a lot of space, but simple, do not need to write a map one by one corresponding;Turn the expression into a stringdef Filter_emoji (desstr,restr= "):‘‘‘Filter Emoticons‘‘‘TryCO = re.compile (U ' [\u00010000-\u0010ffff] ')Exce

caused By:java.sql.SQLException:IncorrectstringValue'\xf0\x9f\x98\x84' forColumn' nickname'At row1At com.mysql.jdbc.SQLError.createSQLException (Sqlerror.java:1074) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:4096) at Com.mysql.jdbc.MysqlIO.checkErrorPacket (Mysqlio.java:4028) at Com.mysql.jdbc.MysqlIO.sendCommand (Mysqlio.java:2490) at Com.mysql.jdbc.MysqlIO.sqlQueryDirect (Mysqlio.java:2651) at Com.mysql.jdbc.ConnectionImpl.execSQL (Connectionimpl.java:2734) at Com.mysql.jdbc.Pre

Tags: mysqld ble ini Beauty's name technology SRC user RACThe records of this blog are operated on LinuxThe project needs to log in from obtaining authorization, and in this process, there was an error saving the emoji emoticons to the MySQL database.The usual Baidu, learned that the UTF8 character set is MySQL only supports 1-3-byte characters, and the expression needs 4 bytes, so MySQL provides a utf8mb4 character set, in support of 4 bytes at the s

The text height calculation in IOS has been a problem, and Apple has been modifying it. Over the past few days, I have read the boundingrectwithsize method. - (CGRect)boundingRectWithSize:(CGSize)size options:(NSStringDrawingOptions)options context:(NSStringDrawingContext *)context NS_AVAILABLE_IOS(6_0); 　　 After several pitfalls, I finally found a better method. Http://stackoverflow.com/questions/13621084/boundingrectwithsize-for-nsattributedstring-returning-wrong-size Notes for use: 1: Each p

An error is returned when the MySQL-emoji emoticons are stored. Solution: Replace the character set utf8 --> utf8mb4 This article reposted an article published on the public platform. A developer reported a problem last week: the front-end application crawls Weibo information. A few pieces of data cannot be inserted every day. Application log display: java. SQL. SQLException: Incorrect string value: '\ xF0 \ x9F \ x92 \ xAA ",... 'For column' raw

Ext.: http://www.cnblogs.com/lvyerose/p/4315894.html#3135760such as QQ, social chat, an integral part of our commonly used expression input, and sometimes interesting expression can also attract users to reach the user's permanent effect, of course, we do not have to study how to do the development of how to be interesting, how to do enough to attract users, We just need to make the required functionality perfectly achievable.Next we simply implement the expression input conversion on the Androi

can see that the client, connection, database, result, and server in the configuration are UTF8MB4. In fact, the completion of the 90%, as long as the verification of the know.Very good, no error, the next query, you can see if you can display the normalThis step is also correct!In this way, we have completed the configuration of the database, but it is also important to note that the current operation of the database, data tables, fields are also required to support the UTF8MB4# for each datab

The expression encoding and decoding problem that was encountered while doing the barrageEmoticons are generally encoded using Unicode encoding, followed by the encoded format \ud83d\ude18\ud83d\ude18world\u4e16\u754chaha\ud83d\ude17 //CodingNSString *unistr =[NSString Stringwithutf8string:[_barragetext.text utf8string]; NSData*unidata =[Unistr datausingencoding:nsnonlossyasciistringencoding]; NSString*goodstr =[[NSString alloc] Initwithdata:unidata encoding:nsutf8stringencoding]; NSLog (@

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, replication error stop MySQL Server serviceModify MY.CNF or Mysql.ini[Client]Default-character-set = Utf8mb4[MySQL]Default-character-set = Utf8mb4[Mysqld]Character-set-client-handshake = FALSECharacter-set-server = Utf8mb4Collation-server = Utf8mb4_unicode_ciinit_connect= ' SET NAMES utf8mb4 'Restart MySQL Server, check c

MySQL needs to support emoji emoticons version requires greater than 5.5.3, and the character set needs to be set to the UTF8MB4 character set. What's the difference between utf8mb4 and UTF8? The original MySQL UTF8 a character up to 3 bytes, while UTF8MB4 expands to a character up to 4 bytes, so it can support more character sets. Converts the MySQL encoding from UTF8 to UTF8MB4. Need to >= MySQL 5.5.3 version, from the library must also be 5.5, t

　　Save emoji to Database

Tags: mysqlSoft text link: http://blog.csdn.net/likendsl/article/details/7530979http://blog.csdn.net/luwei42768/article/details/48732611Show variables like ' character%View SettingsSet character_set_client = UTF8MB4;Set character_set_connection = UTF8MB4;Set character_set_database = UTF8MB4;Set character_set_results = UTF8MB4; Set character_set_server = UTF8MB4;Restart MySQLThis article is from the "Flail Blog" blog, please be sure to keep this source http://jhomephper.blog.51cto.com/8558055/176

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

' character set to UTF8MB4. Double-check this are actually happening–if you ' re running a older version of your chosen framework ' s MySQL client libra Ry, it may isn't have been compiled with UTF8MB4 support and it won ' t set the CharSet properly. If not, with may have to update it or compile it yourself. When viewing your data through to the MySQL client, make sure you ' re on a machine that can display emoji, and run a SET NAMES UTF8MB4 before r

Usage Scenario: PHP as the server-side receive app interface data, due to MySQL format problem caused by no way to directly save emoticons package The solution is to convert the expression to Base64 can be seen in the format, due to the length of