Tagged articles
21 articles
Page 1 of 1
Lisa Notes
Lisa Notes
Feb 21, 2026 · Fundamentals

How to Convert Various Python Data Types to Integers

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.

PythonTutorialbool
0 likes · 4 min read
How to Convert Various Python Data Types to Integers
Architecture Digest
Architecture Digest
Apr 22, 2025 · Databases

Understanding MySQL INT Display Width and ZEROFILL

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.

ZEROFILLdatabasedisplay width
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
Java Tech Enthusiast
Java Tech Enthusiast
Mar 3, 2025 · Fundamentals

Choosing Between int and String for Storing Phone Numbers in Java

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.

Data TypesJVMJava
0 likes · 7 min read
Choosing Between int and String for Storing Phone Numbers in Java
Java Tech Enthusiast
Java Tech Enthusiast
Oct 28, 2024 · Databases

Choosing Between int and string for Storing QQ Numbers

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
Choosing Between int and string for Storing QQ Numbers
ITPUB
ITPUB
Oct 14, 2024 · Databases

How Long Can MySQL AUTO_INCREMENT IDs Last? INT vs BIGINT Explained

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_INCREMENTData TypesSQL
0 likes · 6 min read
How Long Can MySQL AUTO_INCREMENT IDs Last? INT vs BIGINT Explained
macrozheng
macrozheng
Aug 5, 2024 · Databases

Why MySQL int(1) Doesn't Limit Values and How Zerofill Changes Display

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
Why MySQL int(1) Doesn't Limit Values and How Zerofill Changes Display
Test Development Learning Exchange
Test Development Learning Exchange
Aug 3, 2024 · Fundamentals

Understanding Python Magic Methods: __bool__, __int__, __float__, __complex__, __index__, __oct__, __hex__, and __dir__

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
Understanding Python Magic Methods: __bool__, __int__, __float__, __complex__, __index__, __oct__, __hex__, and __dir__
Test Development Learning Exchange
Test Development Learning Exchange
Aug 10, 2023 · Fundamentals

Python Built‑in Functions for Data Type Casting

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
Python Built‑in Functions for Data Type Casting
Programmer DD
Programmer DD
Mar 14, 2022 · Databases

Does MySQL int(1) Limit Your Data? The Truth About Display Width and ZEROFILL

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.

ZEROFILLdisplay widthint
0 likes · 6 min read
Does MySQL int(1) Limit Your Data? The Truth About Display Width and ZEROFILL
Top Architect
Top Architect
Feb 11, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL

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.

SQLZEROFILLdisplay width
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
Laravel Tech Community
Laravel Tech Community
Feb 10, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL Behavior

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 designSQLZEROFILL
0 likes · 4 min read
Understanding MySQL INT Display Width and ZEROFILL Behavior
Python Programming Learning Circle
Python Programming Learning Circle
Sep 29, 2021 · Fundamentals

Common Python Data Types and Their Usage

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
Common Python Data Types and Their Usage