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:Microsoft Windows (XP,NT and 2000)
Assigned to: CPU Architecture:Any

[15 Jul 2005 4:57] Christopher Martinez
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
[15 Jul 2005 6:02] Abdul Mannan
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
[15 Jul 2005 6:22] Aleksey Kishkin
try to change type in the result table from 'float' to 'double' . (or, at least to 'float(10,0)' )
[15 Jul 2005 12:25] Christopher Martinez
I got it.  i change it.  From float to double.
Thanks guys.
God bless you all.