I want to convert a VFP table into a MySQL table.

I tried several converters and they give different results.

For example, a VFP table with these fields:

NPERCNT N(6, 2) Not Null, ;
NAMT N(19, 6) NOT NULL, ;

gives:-
a) The N(6, 2) translates into one of these: DECIMAL(5,2) or DECIMAL(6,2) or DECIMAL(8,2) or DECIMAL(9,2) .
b) The N(19, 6) translates into one of these: DECIMAL(18,6) or DECIMAL(19,6) o DECIMAL(25,6) or DECIMAL(26,6)

That's a wide variety. Can someone suggest which is the best answer?


Also, should Logical fields become BIT, boolean or tinyint(1)?


Cyril