Tagged articles
int
22 articles · Page 1 of 1
This article explains the seven key differences between Java's primitive int and its wrapper Integer, covering default values, memory layout, comparison pitfalls, caching, autoboxing/unboxing, performance impact, and appropriate usage scenarios with concrete code examples and benchmarks.
AutoboxingIntegerJava
0 likes · 22 min read

This tutorial explains why type conversion is needed in Python, describes the int(), str(), float() and bool() functions with their parameters, and provides a concrete example showing how to turn user input from a string into an integer for arithmetic.
PythonTutorialType Conversion
0 likes · 4 min read

A Python community discussion reveals that the bool type is a subclass of int, explaining the relationship between True/False and 1/0, the differences in object identity, the use of __base__, and the distinction between the is and == operators, all backed by code examples and screenshots.
PythonType Systembool
0 likes · 4 min read

This article explains why the number in MySQL's int(N) definition does not limit the column's numeric range, demonstrates that int(1) can store the full 4‑byte unsigned range, and shows how the ZEROFILL attribute adds zero‑padding for display purposes.
MySQLZEROFILLdatabase
0 likes · 5 min read

This article examines why storing phone numbers as Java Strings rather than ints yields better memory usage, semantic correctness, and JVM-level performance, discussing primitive vs reference types, bytecode differences, string pooling, and real‑world case studies.
JVMMemoryString
0 likes · 10 min read

The article clarifies that the number in MySQL's int(N) definition does not restrict the column's numeric range, demonstrates this with insert tests, and explains that only when combined with ZEROFILL does the display width affect how values are shown.
MySQLSQLZEROFILL
0 likes · 4 min read


ITPUBMar 11, 2025 · Databases
This article explains the meaning of the number in MySQL INT(10), how it controls display width with ZEROFILL, shows practical SQL examples, and details the deprecation of integer display width starting from MySQL 8.0.17.
MySQLSQLZEROFILL
0 likes · 5 min read

Because phone numbers are identifiers that can contain symbols and exceed the numeric range of an int, storing them as a String—despite higher memory use—is semantically correct, avoids overflow, preserves formatting, and benefits from JVM string pooling, making String the preferred type in most Java applications.
JVMJavaString
0 likes · 7 min read

While storing early five‑ and six‑digit QQ IDs as int32 or int64 offers memory efficiency and fast queries, the later expansion to eleven‑digit numbers and potential inclusion of non‑numeric symbols makes a string representation preferable to ensure flexible, future‑proof handling of QQ numbers.
QQStringdata type
0 likes · 3 min read


ITPUBOct 14, 2024 · Databases
This article examines MySQL's AUTO_INCREMENT integer types, comparing the 4‑byte INT and 8‑byte BIGINT limits, calculating how long each can store records under realistic insertion rates, and providing step‑by‑step SQL commands and safety tips for converting INT columns to BIGINT.
AUTO_INCREMENTMySQLSQL
0 likes · 6 min read

This article explains why the number in MySQL int(N) does not restrict the column’s numeric range, demonstrates that int(1) can store the full unsigned range, and shows how ZEROFILL combined with a display width pads numbers with leading zeros.
MySQLSQLZEROFILL
0 likes · 4 min read

This article explains that the numeric argument in MySQL int types does not restrict the stored range, demonstrates inserting the maximum unsigned int value, and shows how combining a display width with ZEROFILL pads numbers with leading zeros for formatted output.
ZEROFILLdisplay widthint
0 likes · 5 min read

This article explains Python's special (magic) methods such as __bool__, __int__, __float__, __complex__, __index__, __oct__, __hex__, and __dir__, describing their purpose, how they affect object behavior, and provides concrete code examples demonstrating their usage and output.
boolcode-examplesint
0 likes · 5 min read

While MySQL INT and BIGINT auto‑increment columns usually suffice, this article explains their numeric limits, calculates how many records each can store over time (e.g., at 100 inserts per second), and provides practical steps to switch from INT to BIGINT safely.
BIGINTMySQLauto-increment
0 likes · 6 min read

This article explains why MySQL columns defined as INT(10) appear as INT after upgrading from 5.7 to 8.0, demonstrates the change with reproducible examples, and discusses the storage limits, proper selection, and display‑width behavior of integer types including ZEROFILL.
Integer TypesMySQLSQL
0 likes · 9 min read

This article explains how to use Python's built‑in casting functions—int(), float(), str(), bool(), list(), tuple(), set() and dict()—to convert between numeric, string, boolean, sequence, and mapping types, providing clear code examples for each conversion scenario.
ListPythonbool
0 likes · 14 min read

An in‑depth look at why Python’s Boolean type is actually a subclass of int, covering object identities, the __base__ attribute, and the distinction between the ‘is’ and ‘==’ operators, complete with code screenshots and reference links for further reading.
Type Systembooleanequality
0 likes · 4 min read

Although MySQL’s int type always occupies 4 bytes, the number in parentheses (e.g., int(1) or int(10)) does not restrict its range; only when combined with ZEROFILL does it affect display formatting, as demonstrated by inserting the maximum unsigned int value and observing zero‑padded outputs.
MySQLZEROFILLdisplay width
0 likes · 6 min read

This article explains that the numeric value in MySQL INT definitions (e.g., int(1) or int(10)) does not limit the column's range, demonstrates inserting the maximum unsigned value, and shows how ZEROFILL combined with a display width pads numbers with leading zeros.
MySQLSQLZEROFILL
0 likes · 5 min read

The article explains that the number in MySQL's INT definition (e.g., INT(1) or INT(4)) does not limit the column's numeric range, but only affects display width when combined with ZEROFILL, illustrating the concept with practical CREATE and INSERT examples.
Database DesignMySQLSQL
0 likes · 4 min read

This article introduces Python’s fundamental data types—including integers, floats, booleans, and strings—explaining their characteristics, representation formats, common pitfalls such as floating‑point precision, and provides concise code examples illustrating each type’s usage in Python.
Stringboolfloat
0 likes · 3 min read

This article investigates the meaning of the number in parentheses for MySQL INT types, demonstrates through storage tests that INT(4) and INT(11) have identical storage size and range, and explains how the ZEROFILL attribute changes only the displayed width.
Database DesignMySQLSQL
0 likes · 10 min read
