I set up a mysql database table before I really knew anything about datatypes. Now, I want to go back and clean things up a little.
One of the columns stores numbers (not integers) and I currently have it as a tinytext datatype. (No comments y'all) I actually do need to change it because I want a default value of 0. It isn't just an anal geek thing.
I want to change it to a FLOAT datatype, but I want to make sure that I'm not going to mess up the information that is already stored there.
It worked fine in my test table. Can anyone give me any guidelines for determining if a datatype change will mess something up?
