Re: [mdb-dev] double changed to float from older version of mdbtools

[Jakob E. <jab...@gm...>]

Hi George,

this is just a formating issue. The two numbers are just different ways of writing "15". When you insert "1.5000000000000000e+01" into a numeric field in a MySQL database, MySQL will store the value 15.

Best regards,
Jakob

On 26.01.2012, at 23:58, George L. Emigh wrote:

> I apologize if this is not the correct place to ask about this.
> 
> I am converting my data to MySQL.
> 
> I was using mdbtools-0.6_pre2 but had some issues that 0.7~rc1 seemed to 
> resolve, I was able to build it fine, but one of the problems I have come 
> across is stopping me.
> 
> in the 0.6 version I have a database that mdb-schema reports the Quantity 
> field as:
> Quantity Double
> 
> where 0.7 reports it as
> Quantity  Float
> 
> In 0.6 the value reported by mdb-export is correct, in this example 15.
> in 0.7 the value is reported as 1.5000000000000000e+01
> 
> Is this a bug, or should I just be using 0.6 and working around it's 
> limitations.
> 
> Thank you for your time.
> 
> -- 
> George L. Emigh - AB4BD
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev