Explain the difference between FLOAT, DOUBLE and REAL.
Answers were Sorted based on User's Feedback
Answer / amith
FLOATs store floating point numbers with 8 place accuracy
and take up 4 bytes.
DOUBLEs store floating point numbers with 16 place accuracy
and take up 8 bytes.
REAL is a synonym of FLOAT for now.
Is This Answer Correct ? | 191 Yes | 37 No |
Answer / gurmeet singh
A variable of type float only has 7 digits of precision
where as a variable of type double has 15 digits of
precision. If you need better accuracy, use double instead
of float.
Is This Answer Correct ? | 38 Yes | 4 No |
Answer / mohamad nazim
double has 64 bit- show 8 digith after decimal point
float has 32 bit- show 4 digit after decimal point
Is This Answer Correct ? | 13 Yes | 6 No |
Answer / mastan
Float has 4 bytes it display 8 places accuracy and double
has 8 bytes it displays 16 places accuracy.
Is This Answer Correct ? | 7 Yes | 6 No |
Answer / vibhor
float has 32 bit- show 4 digit after decimal point
double has 64 bit- show 8 digith after decimal point
In short, The float is 32 bit while the double is 64 bit
I prepare job's paper from http://quizplaza.com
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / brianmanee
The Decimal, Double, and Float variable types are different
in the way that they store the values. Precision is the
main difference where float is a single precision (32 bit)
floating point data type, double is a double precision (64
bit) floating point data type and decimal is a 128-bit
floating point data type.
More info... http://net-informations.com/q/faq/float.html
Brian
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / leelu
float is float (4bytes)
double is double of float ;) (8 bytes) !!
Is This Answer Correct ? | 52 Yes | 52 No |
Answer / sanah
In Computer Science terminology(world) Real numbers are those which have decimal points.
These real numbers are categorized in 2 ways.
1.Float and
2.Double
Memory used by these two differs based on the programming language on which we works.
For Example in C:-
Float:-It uses only 4 bytes of memory
Double:-It uses 8 bytes of memory
The only difference between these two is that---
Float can hold only 4 bytes(ex:2.4509)
Double is used to hold 8 bytes(ex:2.450877777777777777779)
i.e
if(real_no is larger)
{
we go for double;//remember double is a real
}
else
{
we go for float;//remember float is also a real
}
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / latha
float is a data type which stores floating values after
the .it takes maximum of 10 bis and it has 4bytes of memory
but in the double it has 8 bytes of memory nd it stores 15
digits after the .(point).
Is This Answer Correct ? | 2 Yes | 5 No |
How many columns can a mysql table have?
What is mysqli_select_db?
What is a deterministic function?
How to store values to array from mysql database in php?
What storage engines are used in MySQL?
How can I remotely connect to mysql database?
What is innodb_buffer_pool_size?
How to rename an existing column in a table?
What are the functions of mysql?
What is mysql root?
How do I change a procedure in mysql?
Which is faster mysql or mongodb?