Tagged articles
21 articles
Page 1 of 1
Liangxu Linux
Liangxu Linux
Jul 14, 2024 · Fundamentals

Decoding Chinese Text: ASCII, GB2312, GBK, GB18030, and UTF‑8 Explained

This article explains how computer text is represented by assigning unique numeric codes to characters and converting those codes into binary, then compares the most common Chinese encodings—ASCII, GB2312, GBK, GB18030, and UTF‑8—detailing their compatibility, byte lengths, and practical impact on software development.

ASCIIGB18030GB2312
0 likes · 14 min read
Decoding Chinese Text: ASCII, GB2312, GBK, GB18030, and UTF‑8 Explained
Sohu Tech Products
Sohu Tech Products
Jul 12, 2023 · Fundamentals

The Mystery of Character Encoding: Unicode, UTF‑8, UTF‑16, GBK and Emoji

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.

EmojiGBKUTF-8
0 likes · 12 min read
The Mystery of Character Encoding: Unicode, UTF‑8, UTF‑16, GBK and Emoji
Programmer DD
Programmer DD
Nov 23, 2021 · Databases

Why MySQL INSERT Fails with Incorrect String Value and How to Fix It

A colleague encountered an "Incorrect string value" error when inserting UTF‑8 text into a GBK‑encoded MySQL table, and the article explains how charset mismatches and the use of the CHAR() function cause the failure, then provides reproducible tests and concrete solutions.

CharsetGBKINSERT error
0 likes · 6 min read
Why MySQL INSERT Fails with Incorrect String Value and How to Fix It
Liangxu Linux
Liangxu Linux
May 13, 2021 · Fundamentals

Why Does Text Become Garbled? A Deep Dive into UTF‑8, GBK, and Unicode

This article explains why characters appear as garbled text when encoding and decoding methods mismatch, explores how Excel defaults to GBK, shows how to convert files with iconv, and walks through the evolution from ASCII to GB2312, GBK, GB18030, and finally Unicode's UTF‑8 encoding.

Character SetGBKUTF-8
0 likes · 6 min read
Why Does Text Become Garbled? A Deep Dive into UTF‑8, GBK, and Unicode
macrozheng
macrozheng
Feb 8, 2021 · Fundamentals

Why Do You See “锟斤拷” in Text? Uncover the Encoding Mystery

This article explains how character encoding works, using ASCII, Unicode, UTF‑8 and GBK examples to reveal why the garbled string “锟斤拷” appears when mismatched encodings are processed, and shows the underlying byte‑level transformations.

ASCIIGBKUTF-8
0 likes · 4 min read
Why Do You See “锟斤拷” in Text? Uncover the Encoding Mystery
Architecture Digest
Architecture Digest
Mar 8, 2020 · Databases

MySQL Encoding Process and Character Set Handling

This article explains how MySQL’s character_set parameters such as character_set_client and character_set_results control the encoding and decoding of client commands and query results, illustrates common pitfalls with UTF‑8, GBK and Latin‑1, and provides practical commands to avoid garbled text.

Character SetGBKUTF-8
0 likes · 10 min read
MySQL Encoding Process and Character Set Handling
Tencent IMWeb Frontend Team
Tencent IMWeb Frontend Team
Sep 13, 2017 · Backend Development

Mastering Character Encoding in Node.js: Avoid Garbled Text

This article introduces the fundamentals of character encoding and decoding, explains the difference between character sets and encodings, and demonstrates practical Node.js examples using the iconv‑lite library to correctly encode and decode Chinese text, helping developers prevent common garbled‑text issues.

Backend DevelopmentGBKNode.js
0 likes · 7 min read
Mastering Character Encoding in Node.js: Avoid Garbled Text
ITPUB
ITPUB
Jun 21, 2017 · Databases

Why MySQL Data Gets Garbled: A Step‑by‑Step Encoding Journey

This article explains the three‑stage encoding and decoding flow when inserting and retrieving data in MySQL, identifies why mismatched character sets cause garbled text, and shows how to ensure consistent charset settings across client, server, and tables.

Character SetGBKUTF-8
0 likes · 5 min read
Why MySQL Data Gets Garbled: A Step‑by‑Step Encoding Journey
ITPUB
ITPUB
Sep 13, 2016 · Fundamentals

Why Does Text Turn into Gibberish? Mastering Encoding and Fixing Garbled Characters

This article explains why text files can become unreadable garbled characters, explores binary representation, locale settings, and common character sets like ANSI and Unicode, and provides practical command‑line techniques such as using iconv to convert between encodings and avoid display issues.

GBKIConvcharacter-set
0 likes · 10 min read
Why Does Text Turn into Gibberish? Mastering Encoding and Fixing Garbled Characters
dbaplus Community
dbaplus Community
Jan 7, 2016 · Databases

Mastering Character Sets: Diagnose and Fix MySQL Garbled Text

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.

EmojiGBKUTF-8
0 likes · 24 min read
Mastering Character Sets: Diagnose and Fix MySQL Garbled Text