We know that there are many kinds of cases that cause outllook system errors and cannot be opened, and the error is different.
One of the causes of Outlook error is because we have failed to transfer the Outlook related files under the system disk, especially when there are other such as Hotmail mailboxes under the same login account, such as the C: User {user name} The Appdatalocalmicrosoftoutlook
Mobile input allows input expression, the expression is actually UTF-16 encoding, in the database storage will be lost, currently if the database Loadline code modified to UTF8MB4 can also be saved.If you do not want to modify the others, you can convert these emoji to the HTML character entity save.The code is as follows:Functionutf16_to_entities () { $content =mb_convert_encoding ($content, ' utf-16 '); $bin =bin2hex ($content); $arr = str_split ($bin, 4); $l =count ($arr); $str = ';for ($n =
Reason:The UTF-8 encoding can be two, three, and four bytes. The emoji expression is 4 bytes, while MySQL UTF8 encodes up to 3 bytes, so data cannot be plugged in.Workaround:Convert MySQL encoding from UTF8 to UTF8MB4Steps:1. Modify the MySQL configuration file My.inidefault-character-Set=utf8mb4character-set-SERVER=UTF8MB42. Join[Client]port=3306default-character-Set=Utf8mb4[mysqld] Add character -Set-client-handshake= falsecollation-server= utf8mb4_general_ciinit_connect ='SET NAMES utf8mb4'3.
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
In daily life, the user sends the content that contains the emoji expression, untreated, in the display is garbled. So this article introduces several processing methods of emoji expression involved in PHP development. We hope to help you.
Background
When you do development, you will find that storing nicknames is essential.
But this evil support emoji expression do nickname, it is a bit of egg pain
The General MySQL table is designed with the UTF8 character set. The nickname field with emoji i
= Json[index];if (val.dic_id = = 16) {//Click the number of hits in the current article +1; if the number of clicks in the library is added successfully, then +1$ (". Like_unlike"). Append ("+val.content_id+ "," +val.click_count+ "," +val.id+ "," +val.dic_id+ "); \" Class=\ "like\" >+val.click_count+ ");}else if (val.dic_id = = 17) {$ (". Like_unlike"). Append ("+val.content_id+ "," +val.click_count+ "," +val.id+ "," +val.dic_id+ "); \" Class=\ "unlike\" >+val.click_count+ ");}});},Error:functi
Is the front-end output of a section such as/:8-) code,
Then in the front of the character to turn into the corresponding QQ expression, ask the great God know how to achieve it?
Reply content:
Is the front-end output of a section such as/:8-) code,Then in the front of the character to turn into the corresponding QQ expression, ask the great God know how to achieve it?
Since it is the code to the expression , then there will definitely be a code and e
be called when called, so we also rewrite these two setter methods in. m files,In order to change the text and font size of TextView in real time, it is also possible to rewrite their setter methodOf course, we customize the control and definitely implement its initialization method:In this case, the custom control method is finished.The third part of the test effectAfter the custom space of course need to test, read is not correct, in this method to modify placeholder and Placeholdercolor two
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
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
Tags: style blog http color io using AR java forPhone end insert emoji expression, save to database times wrong:caused By:java.sql.SQLException:Incorrect string value: ' \xf0\x9f\x98\x84 ' forColumn ' Review ' at row 1At 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.sqlQu
] Character-set-server=utf8mb4 Step 2: In the connector/j connection parameter, do not add characterencoding parameters. When this parameter is not added, the default value is AutoDetect. jdbc.driver_class com.mysql.jdbc.Driver
jdbc.url jdbc\:mysql\://127.0.0.1\:3306/JLBMG? Useunicode\=true
#characterencoding\=UTF8
jdbc.username root
jdbc.password root Step 3: Convert the already built tables to UTF8MB4Command:ALTER TABLE ' table_name ' CONVERT to CHARACTER SET utf8mb4 COLLATE utf8mb4_gener
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.