Tagged articles
garbled text
12 articles · Page 1 of 1
The article explains the difference between character sets and encodings, shows that MySQL’s utf8 is actually an alias for utf8mb3, demonstrates how using the wrong charset or collation causes garbled data, and provides practical steps to consistently use utf8mb4 across versions and connections.
MySQLcharacter-setcollation
0 likes · 13 min read

This article explains three practical methods—using response.content, apparent_encoding, and custom encode/decode—to resolve Chinese character garbling in Python web crawlers, includes code snippets and screenshots, and offers concise guidance for developers facing this common issue.
ChinesePythonencoding
0 likes · 5 min read

This article explains why Chinese characters often appear as garbled text when crawling websites with Python and provides three practical solutions—using response.content, manually setting the response encoding, and applying a generic encode‑decode trick—to reliably decode the data.
CharsetPythonencoding
0 likes · 5 min read

This article explains why the garbled string “锟斤拷” appears in Chinese software, covering basic character encoding concepts, the Unicode replacement character, UTF‑8 decoding failures, and how GBK’s double‑byte scheme turns the placeholder bytes into the visible characters 锟、斤、拷.
GBKUTF-8Unicode
0 likes · 4 min read


ITPUBFeb 28, 2020 · Databases
This article explains the root causes of MySQL character‑set garbling, illustrates the encoding/decoding steps during data insertion and retrieval, and provides practical methods—including dump‑reload and binary conversion—to prevent and repair corrupted data.
MySQLSQLcharacter-set
0 likes · 13 min read

This article explains the fundamentals of character encoding—from Morse‑code analogies and ASCII to Unicode, UTF‑8/UTF‑16/UTF‑32, and Chinese encodings like GB2312, GBK, and GB18030—illustrating how mismatched encodings cause garbled text and how to avoid them.
GBKUTF-8Unicode
0 likes · 10 min read


ITPUBApr 9, 2018 · Databases
This article explains the root causes of MySQL character‑set garbling, details the encoding and decoding steps during data storage and retrieval, and provides practical methods—including dump/reload and binary conversion—to prevent and repair corrupted text.
MySQLcharacter-setcharset conversion
0 likes · 14 min read


ITPUBJun 21, 2017 · Databases
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.
GBKMySQLUTF-8
0 likes · 5 min read


ITPUBSep 13, 2016 · Fundamentals
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


21CTOMar 31, 2016 · Databases
This article explains the multiple encoding/decoding steps MySQL performs when storing and retrieving data, identifies why mismatched character sets cause mojibake, and provides practical methods to avoid and repair corrupted text in MySQL tables.
MySQLcharacter encodingcharset conversion
0 likes · 17 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

This article explains the root causes of MySQL character‑set garbling, illustrates the encoding/decoding steps during data insertion and retrieval, and provides practical methods—including dump‑reload and binary conversion—to prevent and repair corrupted text.
MySQLSQLcharacter encoding
0 likes · 19 min read
