SQL Data Types: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 1: | Line 1: | ||
=External= | |||
* https://www.digitalocean.com/community/tutorials/sql-data-types | |||
=Internal= | =Internal= | ||
* [[SQL#Standard_SQL_Data_Types|SQL]] | * [[SQL#Standard_SQL_Data_Types|SQL]] | ||
Line 6: | Line 9: | ||
=TODO= | =TODO= | ||
<font color=darkkhaki> | <font color=darkkhaki> | ||
* Database-specific data types | * Database-specific data types | ||
* Working with different data types | * Working with different data types | ||
* Conversion functions | * Conversion functions | ||
</font> | </font> | ||
=Numeric Data Types= | |||
==<tt>BIT</tt>== | |||
0,1 | |||
==<tt>TINYINT</tt>== | |||
0..255 | |||
==<tt></tt>== | |||
SMALLINT | |||
-32,768..32,767 | |||
==<tt>INT</tt>== | |||
-2,147,483,648..2,147,483,647 | |||
==<tt>BIGINT</tt>== | |||
-9,223,372,036,854,775,808..9,223,372,036,854,775,807 | |||
==<tt>DECIMAL</tt>, <tt>NUMERIC</tt>== | |||
-10^38 + 1 .. 10^38 - 1 | |||
==<tt>FLOAT</tt>== | |||
-1.79E+308 .. 1.79E+308 | |||
==<tt>REAL</tt>== | |||
-3.40E+38 .. 3.40E+38 |
Revision as of 23:39, 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