Delphi - mySQL

------=_NextPart_000_0003_01C73124.A5938280
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Friends

I have a irritating problem with mySQL installation.
I use=20
Delphi 6
odcb 3.51
and
mySQL 5.1.12
When I try to store floatingpoint variable from Delphi they are =
truncated.
I don't know what is the cause to the problem.
I have tried nearly every solution. Nothing help. Can you help me?

Best regards
S=F8ren Andersen
------=_NextPart_000_0003_01C73124.A5938280--

RE: Delphi - mySQL

S=F8ren 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=3Dgcdmo-myodbc@m.gmane.o rg

RE: Delphi - mySQL

S=F8ren Andersen writes:
> When I try to store floating point variable
> from Delphi they are truncated.

You may also find one of these pages helpful:
http://dev.mysql.com/doc/refman/5.1/en/precision-math.html
http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html
http://dev.mysql.com/doc/refman/5.1/en/problems-with-float.h tml


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg