metinsaylan // rogue developer

How to convert database charset to UTF8

If you need to use UTF8 charset and want to convert your database charset to UTF8 here is a simple way to do it:


  1. Make sure you backup your database (If your database is new no need to think about that)
  2. Now open your notepad and Copy & Paste code below: ```php ```
  3. Edit database username & password data in the code.
  4. Save that file as `convert2Utf8.php` and upload to your site's base/admin directory.
  5. Browse that file using your browser (Eg. `http://myserver.com/convert2Utf8.php`)
  6. Check for the results..

This simple PHP script converts all the tables to UTF8.

Search How to convert database charset to UTF8 on Google