Equivalent of Oracle number type in Mysql 4.x

Posted on 2005-04-06
Last Modified: 2012-05-05

I have to design a db with mysql using data exported from Oracle.
So i need to know the equivalent to the "number" type of Oracle ?

Question by:Richard Coffre
    LVL 6

    Expert Comment

    It depends on your data, what do you have in there?
    It can be either float or int... or both :)
    LVL 11

    Accepted Solution


    Depending upon the length of values you can use these fields. (

    Type                 Bytes       Minimum Value                   Maximum Value
    TINYINT       1               -128                                 127
                                         0                                        255
    SMALLINT      2             -32768                              32767
                                         0                                        65535
    MEDIUMINT    3                   -8388608                           8388607
                                         0                                        16777215
    INT                  4                 -2147483648                       2147483647
                                         0                                         4294967295
    BIGINT                8               -9223372036854775808       9223372036854775807
                                        0                                         18446744073709551615

    There are some 3rd party softwares whcich can convert your oracle database to MySQL database check this link


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now