What data type should i use for a SQL column to store Product version eg. 

Version
0.1
0.1.1
0.2
1.1
1.1.647
2.0
.....

In query i should be able to sort them based on version number and i want an optimal query to find highest number.

Thanks

sql mysql database database-design
Edit
Report