 | | | Delphi - mySQL | Delphi - mySQL 2007-01-08 - By David Dindorp
Back
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/myodbc?unsub=mysql@(protected)
|
|
|