mysql migration tool converts FLOAT to DOUBLE

"Marge May" <[email protected]>
Newsgroups gmane.comp.db.mysql.mycc
Message-ID <20051219125144995.00000002280@ashtanga> 
Generator Microsoft Word 11 (filtered medium) Greetings,
I just migrated a SQL Server 2000 database to mysql 5.0 using the migration tool. I see that some bulkcopy' s failed because some FLOAT fields in source tables were changed to DOUBLE fields in the MySql tables and the values were ' out of range' . I was surprised at this since MySql supports FLOAT.

Anyone know why this happened and how I can prevent it?

Thanks.
marge
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.