[sclug] FW: MySQL & number types

[Chris Aitken]

Morning All,

I have an access db, with some forms & reports, which I have converted to
MySQL db, with an access front end (ODBC)

I need to store numbers such as 2E-5 etc. I don't mind how they are stored
(as general notation 0.00002, or scientific notation 2E-5), as I can massage
that with the Access form, but whatever value I put in, always ends up as 0.
Large numbers such as 1,2, 2000, 2000000 always get displayed correctly, but
I cannot work this for negative exponent numbers.

I have tried Float, decimal, double, etc, but to no avail!

It is MySQL 3.23.49, running on e-smith 5.6

Any help/ideas gratefully accepted.

Cheers

Chris


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.