Change mysql schema and table collation

Posted on June 27, 2012 by Salman, Khwaja | Leave a comment

I was working performancing the Mysql DB and realized that some of my tables needed to be changed to UTF 8 from Latin. Here is the quick script to changing the Mysql schemas and Mysql table.

 ALTER DATABASE `Database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

 ALTER TABLE `table_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Just by changing the Schema does not changes all the tables in it. Individual tables need to be change. All the table, until explicitly told, will be made in the new collation / character set.

[category Mysql, DbAdmin]

Posted on April 27, 2012 by Salman, Khwaja | Leave a comment

One of my friend is coming to UBUNTU AKA Linux world. This post is being re blogged for his help.

Enjoy.

سلمان کے خیا لآ ت

I have installed Ubuntu On my Windows PC and have been enjoying the bells and whistles of Ubuntu since then. I installed it (if I remember it vaguely, October of 2008). Loads of people (Mostly my friends) are asking me how to do this and that. So I decided to document the whole thing. I will be starting with the installation of Ubuntu. The rest will be documented soon.

You need the following things to install Ubuntu on Windows Machine. Windows include Windows XP and Windows Vista.

An Open mind to try UBUNTU. There will be different ways to work, different terminologies to learn. There will be hiccups. So an open mind and an attitude to learn is important.
A basic knowlegde of computers. The difference between a keyboard, mouse display screen and interaction with computer is needed by anyone performing this install. If you do not know what is…

View original post 1,465 more words