Explain the difference between FLOAT, DOUBLE and REAL.

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / amith

14 Answers
70441 Views
Yahoo, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / baba

This is quite a screwed up forum.. All nuckle heads
shitting on the forum..!!!

Is This Answer Correct ?

15 Yes

7 No

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

Answer / leelu

float is float (4bytes)

double is double of float ;) (8 bytes) !!

Is This Answer Correct ?

52 Yes

52 No

Explain the difference between FLOAT, DOUBLE and REAL...

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

Explain the difference between FLOAT, DOUBLE and REAL...

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

Post New Answer