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 database - Mysql

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




Code
  
Rate this page :
  [ 0 votes]

Change charset of a database using alter command as,

Syntax:

ALTER DATABASE dbname DEFAULT CHARACTER SET charset_name;


eg,

ALTER DATABASE test1 DEFAULT CHARACTER SET utf8;




Other Links

web hosting