This article explains Java's primitive data types—including integer, floating‑point, character, and boolean types—covers their memory sizes, value ranges, literal syntax, automatic and explicit type conversions, and provides concrete code examples and tables for reference.
This article explains the fundamental differences between MySQL VARCHAR and CHAR types, covering their definitions, length limits, storage overhead, character‑set effects, practical examples, and guidelines for choosing the appropriate column type in database design.
This article explains how Java’s char type stores Unicode code units in UTF‑16, why its range of \u0000 to \uffff limits direct representation of newer Unicode characters, and how methods like String.length, getBytes, and code‑point APIs help handle multi‑byte characters such as emojis and rare Chinese glyphs.
This article explains how VARCHAR's variable‑length storage and CHAR's fixed‑length storage differ in space usage, memory consumption during queries, and I/O performance, helping developers select the appropriate type for optimal MySQL efficiency.
This article examines Oracle CHAR column behavior in 11g, demonstrating how automatic space padding affects constant, function, and bind‑variable comparisons, showing why queries may unexpectedly return no rows and offering practical tests and conclusions for developers handling CHAR versus VARCHAR2 data.
CHAR stores fixed‑length strings padded with spaces, while VARCHAR stores variable‑length strings with a length byte, leading to different maximum sizes—255 characters for CHAR and up to 65,535 bytes for VARCHAR (about 21,589 UTF‑8 characters)—and distinct use cases such as short fixed fields versus space‑saving flexible fields.
