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
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
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
No details: MySQLALTERDATABASEmy_databaseDEFAULTCHARACTERSETutf8mb4COLLATEutf8mb4_general_ci; ALTERTABLEmy_tableCONVERTTOCHARACTERSETutf8mb4COLLATEutf8mb4_general_ci;
No details about MySQL alter database my_database default character set utf8mb4
Now the mobile side provides a lot of expressions, such as Baidu Input method in the expression.
A lot of expressions in PHP, after it is not recognized content, when stored in MySQL, it will start from the expression position, the contents of the
After the internet has said that the Unicode expression needs mysql5.5.3, my version is MySQL 5.5.38 so is supported, only need to follow the following configuration
Then you can restart the
[Client]default-character-set =
To find a regular expression, replace a regular emoticon with an emoticon (emoticon)
To find a regular expression, replace a regular emoticon with an emoticon (emoticon)
[Happy] to be replaced by (the Chinese name of the picture is not regulated?)
First, download Androidemoji.ttf fonts
Address 1:github Android Platform
Address 2:androidemoji.ttf.zip
Second, the use
2.1 Copy the font to the Assets/fonts directory
2.2 Code calls
try {
typeface typeface = Typeface.createfromasset
Article 3 of the public account development tutorial-sending of symbolic expressions (I ). I believe that this article has made everyone wait for too long. it does not mean that it takes too much time to write an article. Maybe an external question (you can skip it)
I believe this article has made everyone wait for too long. it takes too much time to write an article instead of being confused and appetizing. Maybe it takes 3-5 minutes for you to finish reading an article and learn how to master
], configure the static IP address to set ROUTES = (! Gateway) to ROUTES = (gateway), save and exit (2) select [/etc/resolv. conf, configure the dns server (3) and select/etc/locate. gen], remove all the # Before zh_CN (Simplified Chinese is supported) (4) select [/etc/pacman. d/package list, select the available source address (package repository) (5) and select [/etc/pacman. conf]. Find the following two
file. Modify locale = "en_us.utf8" in the/etc/rc. conf file to locale = "zh_cn.utf8"; comment out the default en_US.UTF-8 and en_us in the/etc/locale. gen file,
At the same time remove the notes of zh_cn.gb18030, zh_cn.gbk, zh_CN.UTF-8, zh_cn.gb2312, and re-run the locale-gen command
4. edit/etc/Pacman. d/hosts list and add the following source
Server = http://mirrors.163.com/archlinux/#repo/ OS /i686
5. Execute the command
Off-topic (can skip)
I believe this article has let everyone wait too long, not my trick, hang everyone's appetite, but write an article really need to spend too much time. Perhaps an article, you spend 3-5 minutes to read, school will master, and I will spend 2-3 hours of time to complete, perhaps only attentively wrote the article the person can understand, hope we can mutual understanding!
Someone once said to me, I write things too elementary, are entry-level things. Well, I admit that tun
1. Filter the reason for emoji expression In our project development, emoji expression is a troublesome thing, even if we can store it, it doesn't have to be perfect, because it's updated fast: On platforms other than iOS, such as PC or Android. If you need to display emoji, you have to prepare a bunch of emoji images
Digress (skipped)
I believe this article has made everyone wait for too long. It takes too much time to write an article instead of being confused and appetizing. Maybe it takes 3-5 minutes for you to finish reading an article and learn how to master it, but it takes 2-3 hours for me to complete it, maybe only those who have carefully written articles can understand it and hope everyone can understand each other!
Some people once told me that what I write is too basic and is an entry level. Wel
Msys has been used before, and recently found there is a msys2, and msys2 supporting compiler is MinGW-w64. I tried to use it. It feels pretty good. Here I will record the installation process.
To put it simply, msys2 is an upgraded version of msys that provides bash shell, autotools, versioning software, and MinGW-w64 tool chains. The biggest difference with msys is that the software package management system Pacman of arch Linux is transplanted. It
blockbuster ..... The test came, and there was a bug.Convex-^ ConvexThere's a bug? (In many cases, we are not fully guided by the thought, and some scenarios are not predictable, so experience is critical)The above code, in the input, the English can be normal restrictions and processing, but if the input characters with emoji emoji, and the user is using the Paste method is likely to be a bug. Look, put a
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.