All geek questions in one place

What is equivalent to the number (4) of the Oracle database for Datatype MySQL?

What would be equivalent to the number (4) of the Oracle database for Datatype MySQL?

+3
source share
1 answer

In Oracle:

The NUMBER data type stores fixed and floating point numbers. Numbers of almost any value can be stored and guaranteed to be portable among different systems working with Oracle, up to 38 digits of accuracy.

7,456,123.89 since NUMBER (9) is stored as 7456124.

Oracle Native DataTypes

In MySQL:

You can use any of the following data types since you do not want to store the decimal part of the value ...

SMALLINT( )  -32768 to 32767 normal 0 to 65535 UNSIGNED.
MEDIUMINT( ) -8388608 to 8388607 normal 0 to 16777215 UNSIGNED.
INT( )   -2147483648 to 2147483647 normal 0 to 4294967295 UNSIGNED.
BIGINT( )    -9223372036854775808 to 9223372036854775807 normal 0 to 18446744073709551615 UNSIGNED.

MySql DataTypes

+3
source

Source: https://habr.com/ru/post/1737575/

More articles:


All Articles