Mysql CAST return invalid data

Mysql CAST return invalid data

References

Reference NO 1

http://stackoverflow.com/questions/15196791/mysql-cast-return-invalid-data

Reference NO 2

http://www.informit.com/articles/article.aspx?p=1238838

Reference NO 3

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

Reference NO 4

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-previous-series.html

Reference NO 5

http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html

Reference NO 6

http://nicj.net/mysql-converting-an-incorrect-latin1-column-to-utf8/

Reference NO 7

http://www.pearsonhighered.com/assets/hip/us/hip_us_pearsonhighered/samplechapter/0672326736.pdf

Reference NO 8

http://thinkdiff.net/mysql/encrypt-mysql-data-using-aes-techniques/