This article explains MySQL's character set and collation variables, illustrates how they interact during data import, analyzes a failure caused by mismatched charset settings, and provides guidance on proper configuration and troubleshooting of encoding problems.
This guide demonstrates how to configure Node.js stdin for UTF-8, read incoming Chinese text, remove question particles and punctuation, replace question marks with exclamation marks, and output the transformed strings, with clear code examples and expected results.
This article explains Unicode and UTF‑8 concepts, then demonstrates in Python 2 on Windows and Linux how encoding and decoding Chinese strings can cause errors, clarifies why str.encode('utf‑8') may still fail, and offers practical solutions for correct string handling.
This article explains why encoding problems frequently arise with Chinese characters in development, clarifies core concepts such as bytes, characters, ASCII, Unicode and UTF encodings, compares Python 2 and Python 3 handling of strings and bytes, and provides practical best‑practice recommendations to avoid encoding bugs.
This article explains how Swift's Codable protocol simplifies converting between JSON and native data structures, covering basic usage, handling nested objects, optional values, key mapping, date formats, enums, dynamic payloads, and custom types for robust iOS development.
This guide explains how to correctly truncate strings containing Chinese characters in PHP by detecting character byte length for GBK and UTF‑8 encodings, and provides a reusable my_substr function with example usage.
This tutorial walks you through installing the WordCloud and jieba packages, resolving common Windows compilation errors, handling Chinese font encoding issues, and creating both basic and image‑masked word clouds with practical code examples and screenshots.
This article explains the origin, alphabet, step‑by‑step conversion process, padding rules, and provides a Java example to illustrate how Base64 encodes binary data into printable characters, highlighting why the output is about one‑third larger than the input.
This technical sharing session by a senior audio‑video engineer from 360 Video Cloud explains core concepts of video and audio, their encoding pipelines, media processing techniques, streaming protocols, and the challenges and key technologies behind real‑time communication (RTC).
This article explains how HttpServletResponse represents server responses in Java web applications, covering methods for sending data, headers, and status codes, demonstrates outputting Chinese characters via OutputStream and PrintWriter, shows numeric output handling, and provides detailed examples of file download implementations with proper encoding considerations.
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.
This article explains why Git on Windows often displays garbled Chinese characters in tools like Git Bash, CMD, PowerShell, and IDEs, and provides step‑by‑step solutions—including Git config changes and environment variable adjustments—to enforce UTF‑8 encoding and eliminate the problem.
This article documents the step‑by‑step conversion of a Python 2.6 script that uses socket.inet_aton() and MD5 hashing to Python 3.4, explaining the differences in return types, required byte‑string handling, and the final optimized solution.
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.
This article explains the fundamentals of character encoding in Python, covering concepts like ASCII, GB2312/GBK, Unicode, UTF‑8, and the differences between Python 2 and Python 3, while illustrating the encoding lifecycle of a .py file with clear examples and images.
This article explains the root causes of MySQL character‑set mojibake, illustrates the encoding/decoding steps during data insertion and retrieval, and provides reliable methods to prevent and repair corrupted text.
The article walks through a hands‑on experiment that shows how inserting the same Chinese string into an Oracle 10g database from clients using different character sets (ZHS16GBK vs AL32UTF8) leads to different stored encodings and results in garbled output, then explains the underlying conversion process and how to avoid it.
This guide explains five common scenarios where Chinese characters appear garbled in Java web applications—JSP pages, servlets, POST form submissions, URI parameters, and properties files—and provides step‑by‑step configurations such as setting pageEncoding, response content type, request character encoding, Tomcat URIEncoding, and using native2ascii.
This article explains the fundamentals of Base64 and Base64‑URL encoding, shows PHP functions for encoding and decoding, illustrates the encoding process with examples, and explores practical applications such as data URLs, MIME email attachments, and common pitfalls to avoid.
This article explains the principles of Base64 encoding, provides PHP implementations for URL-safe variants, illustrates how binary data is transformed into text, and discusses common use cases such as data URLs and MIME while warning against misuse for security purposes.
This article explains Python's two-step encoding conversion, the built‑in error handling options for decode/encode, and how to register custom error handlers to gracefully process mixed‑encoding text and avoid UnicodeDecodeError exceptions.
This article explains why Chinese characters often appear as garbled text on Windows and Linux, introduces the history and hierarchy of Chinese encoding standards such as GB2312, GBK, GB18030 and Unicode, compares ASCII, UTF‑8/16/32, shows practical command‑line experiments, and offers guidance for handling Chinese text in C and Python programs.
