Create an Account
username: password:
 
  MemeStreams Logo

MySQL Manual | A.5.7 Problems with Floating-Point Comparison

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
MySQL Manual | A.5.7 Problems with Floating-Point Comparison
Topic: Technology 6:28 am EDT, Aug 27, 2006

A.5.7 Problems with Floating-Point Comparison

floating-point numbers cause confusion sometimes, because these numbers are not stored as exact values inside computer architecture. What one can see on the screen usually is not the exact value of the number.

Field types FLOAT, DOUBLE and DECIMAL are such.

You cannot just match a float variable from a perl DBI call to a FLOAT value from a field in MySQL. Matching will be totally inconsistent. This link explains how you actually do it.

MySQL Manual | A.5.7 Problems with Floating-Point Comparison



 
 
Powered By Industrial Memetics
RSS2.0