Tagged articles
emoji
40 articles · Page 1 of 1
This article explains why MySQL's utf8 character set only supports up to three bytes per character, causing failures with emoji and complex characters, and details the historical reasons behind this limitation, recommending utf8mb4 for full UTF-8 support.
MySQLRFC 3629UTF-8
0 likes · 10 min read

MySQL's utf8 character set only supports up to three bytes per character, causing errors when storing emoji or complex characters that require four bytes; the article explains the historical reason for this limitation and demonstrates that utf8mb4 is the true UTF-8 implementation introduced in 2010.
MariaDBMySQLUTF-8
0 likes · 9 min read


21CTOSep 17, 2026 · Fundamentals
Unicode 18.0 adds 13,007 characters, raising the total to 172,808, highlighted by 11,328 Chinese seal script characters, Jurchen script, nine new emojis, three currency symbols, and a critical security fix for variation selectors to prevent hidden AI injection attacks.
AI securityChinese seal scriptJurchen script
0 likes · 7 min read


ITPUBDec 2, 2025 · Frontend Development
When debugging a web app, the author discovered that certain emojis occupy more than one character slot in JavaScript strings, revealing that emoji length varies because they are composed of multiple Unicode code points such as variation selectors and zero‑width joiners.
JavaScriptUnicodeemoji
0 likes · 4 min read

Apple's exclusive emojis often appear as unrelated symbols on Android devices, leading to misunderstandings; this article explains the technical reasons behind the display differences, shares real‑world examples, and traces the history and global adoption of emojis from their Japanese origins to today’s Unicode standards.
UnicodeUser Experiencecross-platform
0 likes · 4 min read

This tutorial demonstrates how to import a foreground photo, resize, binarize, rotate, clean, and combine it with a panda‑head background using OpenCV, then add English and Chinese text with Pillow, and finally save the resulting emoji image.
ImageProcessingOpenCVTutorial
0 likes · 9 min read

This article explains the Unicode foundation of Emoji, shows how to insert and style them in HTML, CSS and JavaScript, discusses common pitfalls with surrogate pairs and string slicing, and presents modern solutions such as Intl.Segmenter and libraries like grapheme‑splitter and emoji‑regex for reliable handling.
CSSIntl.SegmenterJavaScript
0 likes · 14 min read

This article explains why emojis become garbled when transmitted via sockets, explores Unicode encoding fundamentals—including UTF‑8, BMP and high‑code‑point characters—and provides practical solutions using codePointAt, TextEncoder, and TextDecoder to ensure correct emoji handling.
SocketTextDecoderTextEncoder
0 likes · 11 min read

Using Android Profiler we discovered that deleting many custom emojis in an EditText triggers repeated DynamicLayout ChangeWatcher calls, causing up to two‑second lag, and by adopting the emoji2 library’s EmojiSpan rendering with a custom EditableFactory that suppresses onSpanChanged for emoji spans, the lag is eliminated.
AndroidEditTextSpannableStringBuilder
0 likes · 10 min read

This article explains why inserting emoji characters into a MySQL table defined with the default utf8 charset triggers a string‑value error, explores the underlying encoding and charset concepts, compares utf8mb3 and utf8mb4, and shows how to convert tables to avoid such failures.
MySQLcharacter-setcollation
0 likes · 9 min read

This article explains why MySQL’s built‑in utf8 charset only supports three‑byte characters, why emojis cause errors, and how switching to the proper utf8mb4 charset resolves insertion issues while preserving full Unicode support.
MySQLcharacter-setdatabase
0 likes · 9 min read

The article explains why MySQL’s built‑in utf8 charset cannot store four‑byte characters such as emojis, demonstrates the resulting insert error, shows how switching the database, table and connection to utf8mb4 fixes the issue, and recounts the historical reasons behind MySQL’s limited utf8 implementation.
MySQLcharacter-setemoji
0 likes · 8 min read

This article explains the differences between utf8, utf8mb3 and utf8mb4 character sets in MySQL, demonstrates how utf8mb4 enables full Unicode support including emojis, and provides step‑by‑step SQL examples for creating tables, inserting data, and querying results with the proper character set.
MySQLUnicodeemoji
0 likes · 12 min read

Java 21 introduces six static methods in java.lang.Character that let developers reliably detect emojis, emoji presentations, modifiers, modifier bases, components, and extended pictographic characters using Unicode code points, with practical code examples and regex usage.
Unicodeemoji
0 likes · 4 min read

This article explains the fundamentals of character encoding, covering Unicode’s universal character set, the structure of its planes and surrogate areas, the variable‑length UTF‑8 and UTF‑16 encodings, Chinese‑specific GBK encoding, and practical iOS code examples for handling Unicode, emojis and regular‑expression based Chinese character detection.
GBKUTF-8Unicode
0 likes · 12 min read

This article explains how emojis are represented in Unicode, covering basic code points, variation selectors, skin‑tone modifiers, zero‑width joiners, flag ligatures, tag sequences and keycap symbols, and shows how JavaScript can correctly process them using grapheme‑cluster techniques.
Unicodecharacter encodingemoji
0 likes · 16 min read

This article explains why MySQL's built‑in utf8 charset is not true UTF‑8, how inserting 4‑byte emoji characters triggers errors, and why switching the database, tables, and connection to utf8mb4 resolves the issue, along with a brief history of MySQL's encoding decisions.
character encodingemojiutf8mb4
0 likes · 9 min read

This article explains why MySQL's default utf8 charset cannot store four‑byte characters such as emojis, demonstrates the resulting insertion error, and shows how switching to the utf8mb4 charset resolves the issue while also covering the historical reasons behind MySQL's limited utf8 implementation.
MySQLSQLcharacter-set
0 likes · 8 min read

This article explains why MySQL's default utf8 charset cannot store four‑byte characters like emojis, demonstrates the resulting insert errors, and shows how switching to the utf8mb4 charset resolves the issue while providing a brief history of MySQL's encoding decisions.
MySQLSQLcharacter encoding
0 likes · 8 min read

This article explains why MySQL’s legacy utf8 charset only supports three‑byte characters, causing emoji insertion failures, and shows how switching tables, columns, and the database to utf8mb4 resolves the issue while detailing the historical reasons behind MySQL’s limited utf8 implementation.
MySQLSQLcharacter encoding
0 likes · 9 min read

The article explains how to enforce a custom length limit in JavaScript input fields that counts English letters and numbers as half a unit, Chinese characters as one unit, and each emoji as one unit, using Unicode code‑point detection, regex extraction, and automatic truncation to prevent overflow.
Front-endJavaScriptLength Calculation
0 likes · 10 min read

This article explains why JavaScript's string length property returns unexpected values for Unicode characters like emojis, explores UTF‑16 encoding rules, and demonstrates modern ES6 techniques—including for‑of loops, spread syntax, and the \u{…} and /u regex flags—to correctly handle Unicode strings.
ES6JavaScriptUTF-16
0 likes · 9 min read

This article explains how JavaScript's spread operator works with arrays, objects, and strings, clarifies why strings are iterable, demonstrates using for...of loops, and shows how zero‑width joiners enable the creation of complex emoji sequences.
JavaScriptSpread Operatoremoji
0 likes · 5 min read

This article explains why inserting emoji into MySQL fails with the default utf8 charset, demonstrates how switching to utf8mb4 resolves the issue, and provides a historical overview of MySQL's limited utf8 implementation and the proper use of true UTF‑8 encoding.
MySQLUnicodecharacter-set
0 likes · 7 min read

Using Python web‑scraping, translation APIs, and text‑analysis techniques, this article compares Chinese, Japanese, and Korean netizens’ reactions to Netflix’s Squid Game, presenting rating statistics, popular keywords, emoji usage, and visualizations such as word clouds to reveal cultural perception differences.
Squid Gameemoji
0 likes · 6 min read

This article explains the difference between MySQL’s utf8 and utf8mb4 character sets, why utf8 cannot store emojis or complex Chinese characters, and provides step‑by‑step examples showing how to configure tables and columns with utf8mb4 to avoid encoding errors.
MySQLcharacter-setemoji
0 likes · 10 min read

This article provides a Python script that uses the pynput library to automate keyboard and mouse actions, randomly sending a wide range of WeChat emoji expressions to a chat window, with user‑controlled repeat count and interactive prompts for continued execution.
WeChatemojipynput
0 likes · 5 min read

This article explains why strings containing emojis report different lengths in JavaScript, covering Unicode fundamentals, code points, UTF‑8 and UTF‑16 encodings, surrogate pairs, grapheme clusters, zero‑width joiners, and modern ES2015‑ESNext features that help handle Unicode correctly.
JavaScriptUTF-16UTF-8
0 likes · 15 min read

This article explains why MySQL's legacy utf8 charset cannot store four‑byte characters such as emoji, demonstrates the resulting insertion error, and shows how switching the database, table, and column collations to utf8mb4 resolves the issue while also covering the historical reasons behind MySQL's limited utf8 implementation.
MySQLcharacter-setemoji
0 likes · 7 min read

This guide explains how to add Unicode emoji rendering to Laravel projects by installing the Laravel Emoji package, configuring its service provider and alias, and using its facade methods to retrieve emojis by alias, name, or Unicode code point.
BackendLaravelPHP
0 likes · 3 min read

Emoji and emoticons evolved from prehistoric cave drawings and 19th‑century printed symbols to today’s ubiquitous digital icons, reflecting shifts in communication technology, cultural practices, and user‑generated content, while influencing language, emotion expression, and even gaining official recognition in dictionaries.
cultural historydigital communicationemoji
0 likes · 10 min read

The article explains why MySQL’s built‑in utf8 charset only supports up to three‑byte characters, causing insert errors with four‑byte emojis, and shows how switching tables, system, and connection settings to utf8mb4 resolves the issue while detailing the historical reasons behind this limitation.
character-setdatabase encodingemoji
0 likes · 9 min read


58UXDMay 28, 2020 · Frontend Development
This article explains how web fonts are rendered, why the same design draft can show different typefaces on Windows and macOS, and provides practical guidance on using the CSS font-family property, including handling of common fonts and Emoji symbols to achieve consistent, cross‑platform typography.
CSSFrontend DevelopmentUI design
0 likes · 10 min read

This article explains how to add Unicode emoji rendering to a Laravel application by installing the Laravel‑Emoji extension, configuring Composer, registering the service provider and alias, defining a route, and using the Emoji class in a controller to convert aliases, names, and Unicode codes into emoji graphics.
BackendComposerLaravel
0 likes · 4 min read

This article explains Unicode's structure, encoding ranges, UTF-8/16/32 representations, byte order considerations, and provides Java code to detect emojis in strings, illustrating practical usage of Unicode concepts for text processing.
JavaUTF-16UTF-8
0 likes · 14 min read

This article explains the Unicode standard, its code planes and ranges, the three UTF encoding forms (UTF-8, UTF-16, UTF-32), compares their storage characteristics, discusses byte order marks, and provides Java code for detecting emoji characters in strings.
JavaUTF-16UTF-32
0 likes · 11 min read

The article details Xianyu’s migration of its messaging rich‑text system to Flutter, explaining how RichText became a MultiChildRenderObjectWidget, how custom emoji placeholders are converted to HTML tags and parsed into TextSpan and WidgetSpan elements, enabling colored text, clickable links, and emoji rendering across Flutter versions.
FlutterRichTextUI
0 likes · 9 min read

This article explains how to develop an Android input‑method service that displays a custom emoji keyboard, retrieves image paths, commits them to the active app, and uses AccessibilityService to automate sending, covering project setup, core APIs, XML keyboard layout, and advanced optimization techniques.
AccessibilityServiceAndroidInputMethodService
0 likes · 18 min read


ITPUBJul 21, 2017 · Databases
This article explains why MySQL throws "Incorrect string value" when storing emojis, how utf8mb4 solves the problem, and provides step‑by‑step instructions—including table conversion, my.cnf changes, connector upgrades, and runtime workarounds—for reliable emoji storage.
JDBCMyBatisMySQL
0 likes · 7 min read

This article explains character sets and encodings, shows why MySQL data can become garbled, and provides step‑by‑step methods—including proper configuration, common pitfalls, and reliable repair techniques—to prevent and correct encoding issues such as emoji storage failures.
GBKMySQLUTF-8
0 likes · 24 min read
