FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


SQL datatype





eudbase
May I know which datatype should I use for an exponential number like this...
1.00E-99
2.00E-55

It is scientific notation of exponential number, I need it to be calculatable even when store in database, but the trouble is, which datatype should I use?
rvec
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
floating point numbers
so float
AftershockVibe
How precise do your numbers need to be? Floats are good for numbers across large ranges by they do lose accuracy.
Floats is the answer you are looking for though, just be aware that they aren't infinitely precise.
kv
AftershockVibe wrote:
Floats is the answer you are looking for though, just be aware that they aren't infinitely precise.


No datatype -- however big it is -- is infinitely precise Very Happy
Peterssidan
kv wrote:
No datatype -- however big it is -- is infinitely precise Very Happy

INT is infinitely precise for integers that aren't too big Razz
AftershockVibe
Peterssidan wrote:
kv wrote:
No datatype -- however big it is -- is infinitely precise Very Happy

INT is infinitely precise for integers that aren't too big Razz


I think he meant that integers aren't infinitely precise due to the fact that they are inherently integers Wink

Any datatype can be infinitely precise... just as soon as you find infinite memory to store them in.
Related topics
Help: SQL error after uploading new files(thread updated)
SLOW UPLOADING AN SQL FILE
have problem on my sql
SQL Basics
SQL Tutorial
Executing a .sql file through PHP
I can't upload my Database SQL script ! Helllppppp!!!!
SQL
SQL
SQL and PHP
Is there such a wsiwyg editor for sql
SQL Server 2000 and MYSQL, pls help me.
Can I create many SQL database by my self
Hacked by someone sql Injection
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.