I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns which contains float values things go weird. Any data that is newly uploaded regardless of the size of the float gets placed first when I order by that column in ascending order. For instance, if I ALREADY had these floats:
100.2, 101.2, 150.5 before in the sqlite database and then after moving them to mySQL I append to that list something like
100.5 when I order them using
SELECT * FROM TABLE ORDER BY float ASC instead of getting
100.2 100.5 101.2 150.5 I get
100.5 100.2 101.2 150.5 even if I then appended something like 300.5 it would just insert the 300.5 in between 100.5 and 100.2. Any ideas why? The collation is same between the two but it just won't order them correctly, any thoughts as to why?