Talk:Converting your MySQL database to UTF8: Difference between revisions
From MoodleDocs
(UTF8 using Phpmyadmin->cPanel) |
(→Converting latin1 to utf8: new section) |
||
Line 7: | Line 7: | ||
Thanks, | Thanks, | ||
Danica | Danica | ||
== Converting latin1 to utf8 == | |||
I had the same problem with converting DB from latin1 to utf8. And that how I did it: | |||
1. Export your DB to somedb.sql on your pc. | |||
2. Open dump in MS Word: | |||
2.1. It will ask you in wich charset to convert(open) - show utf-8 | |||
3. Find and replace all words latin1 to utf8 | |||
4. Save file as somedb.txt | |||
5. Change extension txt to sql | |||
6. Drop the old DB on server | |||
7. Upload(import) new dump to server. | |||
8. Check your site | |||
Done. |
Revision as of 08:39, 17 February 2011
Hi,
Could you help me how to convert to UTF8,im using Phpmyadmin in cPanel.
Hope somebody could help me.
Thanks, Danica
Converting latin1 to utf8
I had the same problem with converting DB from latin1 to utf8. And that how I did it:
1. Export your DB to somedb.sql on your pc. 2. Open dump in MS Word: 2.1. It will ask you in wich charset to convert(open) - show utf-8 3. Find and replace all words latin1 to utf8 4. Save file as somedb.txt 5. Change extension txt to sql 6. Drop the old DB on server 7. Upload(import) new dump to server. 8. Check your site Done.