MySQL Forums
Forum List  »  Oracle

MySQL type equivalent to Oracle NUMBER
Posted by: Peter Steinhoff
Date: September 16, 2015 08:40AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL type equivalent to Oracle NUMBER
2238
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.