Extract animated gif from MS Powerpoint for mac

You may all have noticed by now that the save as web page is not an option on Power point for mac 2011, so there is no easy way to extract animated Gifs from power point presentations, one way is to add .Zip after .pptx at the end of the file then open it as a zip file, you will find a lot of folders, you will find the images in a folder named media, do some search till you find the needed file, and thats it :)

Convert character set to utf8 in MySQL

Say, you had a MySQL database that stores texts in languages such as Chinese, Japanese, Korean, Hebrew, Arabic, and so on, and recently there was a server move or upgrade, and all of sudden text in the above mentioned languages didn’t display properly. What do we do to fix it then?
see this post for details

Latex::Wrong figure numbering and in figure citation

I had a problem when i was preparing a journal of mine, that made me nearly crush my mac, some figures were referenced wrongly in roman letters , no matter what i do. after a long search on the internet, i found that this sort of error has one of two sources (and for my luck, i had them both :) )
1- For some reason you can't put \cite or \ref commands inside caption \protect\ref{fig:xxx} or \protect\cite{xxx}.
2- The other thing is you have to put \caption , \label , \end{center} , in the same mentioned order :) , sometimes it work if you use different order, but for my case it didn't ...

and thats it