Altering charset of a mysql table column

Posted: Saturday, September 25, 2010 by Venkat Pola in Labels:
0

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



Enhanced by Zemanta

0 comments: