Hi all, I am building some views from a mysql table but why does the column datatypes does not match in vfp ?

For example a numeric value of length 6 appears there as length 1 and how to set every field, can't this be done automatic ?

Thanks