MDB2 shortening floats

[Pig]

I am using MDB2 with a MySQL database. When I retrieve values stored as floats in the database they are truncated to 3 decimal places.

I tried setting the column type to float in the query. Tt does come back as a float, but it still truncates decimals.

Has anyone encountered this?

TIA.

[NogDog]

It might be useful to view the exact column definition used in the MySQL table definition. For instance, MySQL allows for FLOAT type columns to defined as:

column_name FLOAT(6,3)

This would mean that there would be a maximum of 6 significant digits, with no more than 3 of them to the right of the decimal point.

[Pig]

Thanks.

MySQL only uses precision to determine storage size, and is optional. On my table, precision isn't used. The data is in there, it just gets borked when I query it with MDB2.

[NogDog]

If you are sure the data is in there, then no, I do not know why MDB2 functions would not be extracting all of it (assuming they are the problem, without having seen any code). But as a FYI side-note, according to http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html:

MySQL allows a non-standard syntax: FLOAT(M,D) or REAL(M,D) or DOUBLE PRECISION(M,D). Here, “(M,D)” means than values can be stored with up to M digits in total, of which D digits may be after the decimal point.

[Pig]

Ahh, thanks for that. I didn't realize they had their own format.

Thanks for your thoughts.