MySQL Bugs: #11955: Data type is in different format

Bug #11955	Data type is in different format
Submitted:	15 Jul 2005 4:57	Modified:	15 Jul 2005 12:34
Reporter:	Christopher Martinez	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.x,4.12	OS:	Windows (XP,NT and 2000)
Assigned to:		CPU Architecture:	Any

Description:
I export a table from MS SQL to MySQL.
Some of the fields that was exported is ok, except the fields wich has a data type of float.

I have a field name CTRL_NO, and its field type is float.
this is the sample result.

3.02011e+007
3.02011e+007
3.02011e+007
3.02011e+007
3.02011e+007
3.02011e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007
2.08835e+007

but when i query it on MS SQL the values should be something like this

CTRL_NO

30201080
30201081
30201082
30201083
30201084
30201085
20883477
20883478

why is it that when i exported it on MySQL it makes the values in different format like 2.08835e+007.  It should not be like this.  I have exported all my tables from MS SQL to MySQL and this is the problem that i encounter. 

Please help me.  Thanks.
 

How to repeat:
Creat a table form MSSQL

table name is TBL_MS
field name is CTRL_NO, length=8, precision =53, type=float

insert these values
30201080
30201081
30201082
30201083
30201084
30201085
20883477
20883478

then export it to MySQL

Did you check the value of "3.02011e+007" after convering it to not "e" form
for example if you write 9 by 16 times mysql converts it to "1E16"

Regrds.
M. Abdul Mannan
itsmani1@hotmail.com

try to change type in the result table from 'float' to 'double' . (or, at least to 'float(10,0)' )

I got it.  i change it.  From float to double.
Thanks guys.
God bless you all.