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

[George L. E. <ab...@ge...>]

Thank you, it kinda freaked me out a bit, ran into another problem, wanted 
to add a prefix to the table names using the -N <namespace> option.

for -N qp mdb-schema gives:
DROP TABLE [qp_Customer Table];
CREATE TABLE [qp_Customer Table]

which is what I expected, but mdb-export -I mysql -N qp gives:
INSERT INTO qp`Customer Table` (

Namespaces is not mentioned in the man pages but is when you run the command 
without any options, is Namespaces going to be removed?

Also I see the sanitize option is gone, will that option to convert spaces 
to underscores be coming back?  I liked the feature, convert all fields and 
table names to lowercase would be nice too, but for now I'll just alter my 
tables after the conversion.

Thank you so very much for the work you have done making this cool tool.

George



Jakob Egger wrote:

> 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
> 
> 
> 
------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> 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-dev2
-- 
George L. Emigh - AB4BD