Floating Point Data error

[Fred]

I am attempting to migrate a MS SQL Server 2000 DB (Development Version) to
MySQL 5.0 using the MySQL Migration Toolkit (Windows XP). Several of the tables
have error messages such as "Data truncation: Out of range value adjusted for column 'CompBudget5' at row 8 - 180 row(s) transferred.. " The data in these tables is corrupted.

The problem shows up as all floating point numbers larger than "10" are truncated to "10". For example "4.5" is transferred as "4.5" while "21700" is transferred by the Migration Tool Kit as "10". The value of "9.564869" is properly transferred while "11.234564" ends up as "10".

The field is properly mapped as Double(53,30) but something gets broken if the number is greater than 10. Attempts to change the data in these fields to a number greater than 10 fail when using ODBC tools such as MS Access or Navicat. The fields will not accept a value larger than 10.

Can be repeated by transferring a table with fields defined as Float and inserting numbers larger than "10".

I am viewing the migrated data through the ODBC connection utilizing both MS Access and Navicat.

I assume that we must have made an error during the migration since I do not see this problem posted by any other users and assume everyone must use at least some floating point data.