MySQL and Data Truncation: A descent into IEEE hell

I run into this warning all the time. It forces me to double-check. Finally I understood the reason. And it was an interesting read too!