missing 7th digit in float

[email protected]
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
Hi all,

my environment: WindowsNT4 with SP6, mysql4.0.15-max-nt
A select from a float field created with
      create table ... (..., float)
or with
      create table ... (..., float(24))
returns only 6 significant digits - the standard requires 7!
Only
      create table ... (..., float(24,7))
works as expected.
Is this a bug, do I have to define every float field with "float(24,7)" or
is there a configuration option for this?

Regards

Peter Bernhardt


Hessisches Statistisches Landesamt
Rheinstraße 35/37
65185 Wiesbaden

Telefon: 0611 3802-165
Telefax: 0611 3802-190
Internet: http://www.hsl.de




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.