|
|
change table column charset in mysql - Mysql
|
Views : 398
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
change table column charset in mysql:
Whenever you create a table in mysql database, it takes default charset "latin1_swedish_ci". Hence to change table column charset in mysql use Alter command as,
ALTER TABLE tablename CHANGE `fieldname` `fieldname` datatype CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL |
|
By Ramya, On - 2010-12-03 |
|
|
|
