MySQL type equivalent to Oracle NUMBER
Does MySQL have an equivalent data type to Oracle's NUMBER?
That is NUMBER without any precision or scale (not NUMBER(X,Y)) so any of these values could be stored and read without being rounded or changed:
123
123.4
12.34567
123345
etc.
When I try to use just DECIMAL (without any precision & scale) in MySQL I get DECIMAL(10,0).
I'm upgrading from Oracle 11g to MySQL :-)
Any ideas?
Subject
Views
Written By
Posted
MySQL type equivalent to Oracle NUMBER
3803
September 16, 2015 08:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.