Mysql Programming Tips & Tricks





Español Français 中文 Deutsch Portuguese Japanese nederlands
   
 
Code Snippets
 List All
 Datatypes
 Other Queries
 Tables
 




change default charset of a table - Mysql

Snippets  Mysql  Change default charset of a table
Snippet On
table charset




Code
  
Rate this page :
  [ 0 votes]

Change charset of a table using alter command as,

Syntax:

ALTER TABLE table_name DEFAULT CHARACTER SET charset_name;

eg,

ALTER TABLE test1 DEFAULT CHARACTER SET utf8;




Other Links

web hosting