1 views collected around this technical thread.
An investigation reveals that MySQL treats trailing spaces in VARCHAR values as insignificant during string comparison, causing queries like SELECT * WHERE name='Tom' to match rows with extra spaces, and demonstrates that using the BINARY keyword restores exact matching, highlighting a potential bug in MySQL 5.7.
This article explains the structure of IPv4 addresses, walks through a Rust function that parses dotted‑decimal notation into a 32‑bit integer with range checks, and provides example code demonstrating usage and error handling.
This article explains how CPUs interpret binary signals as voltage levels, describes basic logic gates such as AND, OR, NOT, shows how they combine to perform arithmetic like addition, and clarifies that hardware itself lacks understanding, relying on human-designed instruction sets and compilers to give meaning to 0s and 1s.
This article demonstrates how MySQL silently discards trailing spaces in VARCHAR columns during queries, shows example tables and queries where spaces are ignored, and explains how to use the BINARY keyword to enforce strict matching of trailing spaces.
From its appearance as a rescue signal in a thriller film to its role as a triangular number, a sum of primes, and a culturally charged symbol, this article explores the many mathematical properties and cultural meanings of the number 666.
This article investigates why MySQL treats strings with trailing spaces as equal during "=" comparisons, explains the underlying PAD SPACE collation rule, and demonstrates how to perform exact matches using LIKE and BINARY operators with practical examples and code snippets.
This tutorial explains the origins and evolution of character encoding, covering early ASCII, Chinese GBK/GB18030, the universal Unicode standard, UTF‑8 variable‑length encoding, and practical differences between Python 2 and Python 3 with code examples.
This article narrates how two friends transform secret light‑bulb blink codes into binary representations, then progressively design logic gates, adders, a full‑adder, RAM, an ALU and a programmable control unit, illustrating the fundamentals of digital circuit design and automation.
This article explains how to use PHP's built‑in decbin() function to convert decimal integers into their binary string representation, covering the function syntax, parameter details, return limits, and providing a clear code example with expected output.
A classroom tale follows elementary students as they discover binary counting with their fingers, translate it into truth tables, explore AND, OR, and NOT gates, and progressively build one‑bit and multi‑bit adders, illustrating fundamental digital logic concepts.
This article explains the concept of object serialization, compares generic formats like JSON/XML with binary approaches, discusses optimization principles, key performance metrics, and reviews major serialization frameworks such as Protobuf, Thrift, Hessian, Kryo, and Avro, while also covering TLV encoding, varint algorithms, and practical pitfalls.
Explore the essential building blocks of modern computing, covering CPU architecture, memory hierarchy, binary operations, compression techniques, operating system fundamentals, and assembly language, with clear explanations, diagrams, and code examples that demystify how hardware and software interact at the lowest level.
This article introduces five classic bitwise operation examples in Java—including checking odd/even, swapping variables without a temporary, finding a unique number, fast exponentiation, and determining the greatest power of two not exceeding N—explaining the underlying binary logic, code implementations, and their efficiency advantages.