QuickTopic (SM) free message boards QuickTopic (SM) free message boards
Skip to Messages
  Sign In to access your topic list  |New Topic |My Topics|Profile
Upgrade to Pro   Customize, show pictures, add an intro, and more:   QuickTopic Pro...and check out QuickThreadSM
Topic: Storing fixed point numbers in MySQL
Views: 3372, Unique: 1691 
Subscribers: 1
What's
this?
Printer-Friendly Page
Subscribe to get & post, or stop messages by email Subscribe
All messages    << 8-16  7-7 of 16  1-6 >>
About these ads
Who | When
Messagessort recent-bottom   
Post a new message
 
rafecoPerson was signed in when posted  7
01-03-2005 08:33 AM ET (US)
Two things. The first is that there is a floating point conversion somewhere along the way.

If I run the query:

insert into num_example values (1.1)

the resulting value is:

1.100000000000000100000000000000

So it's not just an overflow problem (although there is an overflow problem there).
RSS link What's this?
All messages    << 8-16  7-7 of 16  1-6 >>
QuickTopicSM message boards
Over 200,000 topics served
Learn more Frequently asked questions  Acknowledgements
What they're saying about QuickTopic
 Questions, comments, or suggestions? Contact Us
Read our use policy before beginning. We value your privacy; please read our privacy statement.
Copyright ©1999-2008 Internicity Inc. All rights reserved.