RE: Delphi - mySQL
"David Dindorp" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Søren Andersen writes: > When I try to store floating point variable > from Delphi they are truncated. What field type are you storing into? What is the exact problem you're seeing? FLOAT and DOUBLE fields are rounded on SELECT but stored with higher precision by the server. In other words, these field types are broken by design in MySQL Server. If this is what you're experiencing, you might be able to get the server to do something sensible by specifying an exact precision for your fields by defining them as eg. DOUBLE(x,y). -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]