SQL Data Types: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 18: | Line 18: | ||
==<tt>TINYINT</tt>== | ==<tt>TINYINT</tt>== | ||
0..255 | 0..255 | ||
==<tt></tt>== | ==<tt>SMALLINT</tt>== | ||
-32,768..32,767 | -32,768..32,767 | ||
==<tt>INT</tt>== | ==<tt>INT</tt>== | ||
-2,147,483,648..2,147,483,647 | -2,147,483,648..2,147,483,647 |
Revision as of 23:40, 22 May 2024
External
Internal
Overview
TODO
- Database-specific data types
- Working with different data types
- Conversion functions
Numeric Data Types
BIT
0,1
TINYINT
0..255
SMALLINT
-32,768..32,767
INT
-2,147,483,648..2,147,483,647
BIGINT
-9,223,372,036,854,775,808..9,223,372,036,854,775,807
DECIMAL, NUMERIC
-10^38 + 1 .. 10^38 - 1
FLOAT
-1.79E+308 .. 1.79E+308
REAL
-3.40E+38 .. 3.40E+38