> ## Content Index
> Fetch the complete content index at: https://yovko.net/llms.txt
> Use this file to discover other available public pages before exploring further.

# WordPress loves UTF-8
- URL: https://yovko.net/wordpress-loves-utf-8/
- Published: 2004-10-11T00:01:04.000Z
- Updated: 2020-12-27T12:37:17.000Z
- Author: Йовко Ламбрев
- Tags: Технологии, #en

Well, my blog was windows-1251\. Terrible, isn’t it? Almost everyday I talk around that every project on the web should be unicode, but my own blog was not UTF-8 encoded. The problem was the collected cp-1251 content.

Today the conversion has been done. The procedure is very simple:

1. Backup your current database  
`mysqldump --opt -u user --password="pass" dbname > wpdb.sql`
2. Convert your dump file with *iconv*  
`iconv -f WINDOWS-1251 -t UTF-8 wpdb.sql > wp-conv.sql`
3. Drop your current database and re-create it again. Leave it empty.
4. Import converted dump file into new database.  
`mysql -p dbname < wp-conv.sql`
5. Set your WordPress (Options – Reading – Encoding) to use UTF-8 enconding
6. Enjoy