Techie musings

Altering whole table:-

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;


Altering particular table column:-
alter table table_name CHANGE column_name column_name VARCHAR( 120 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;


Viewing complete table information with charset information:-
SHOW CREATE TABLE table_name