// you’re reading...

Technology

Changing the Character Set and Collate of your MySQL Database

Before changing the Char Set of your Database, here’s How to view the character set and collate of your database:

use YOUR_DATABASE_NAME;

show variables like “character_set_database”;

show variables like “collation_database”;

Now that you know your Database isnt UTF-8, you can try Changing the character set from Latin to UTF 8:

alter database YOUR_DATABASE_NAME charset=utf8 collate=utf8_bin;

Share This:
  • Print this article!
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • MySpace
  • Reddit
  • RSS
  • Twitter

Discussion

No comments for “Changing the Character Set and Collate of your MySQL Database”

Post a comment