Re: missing 7th digit in float

[email protected] writes:
> 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
> 

HI!

The above is expected behaviour. If you do not specify decimals a
default will be used.

Also, for higher number of significant digits then 7 you should use double.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]