hello,
new here but i think you should know how i convert to utf-8
1) backup your database, just say copy to a new one with phpmyadmin, so you have same data in 2 databases with different names
2) take the copy and export the data to mysql.
3) create a new database and set charset to utf8_general_ci (actually i use utf8_romanian_ci)
in the exported database as sql go and find something like
| Code: |
CREATE TABLE `....
DEFAULT CHARSET=utf8;
|
change the default charset to utf8
4) paste the modified code and run sql
if someone could convert what i said here (my english is very poor)
additional you can install joomla international in a new database and than import only the data. than you should export from your original database only the relevant data you want without have to create the new tables.
if you have large data consider to increase the php parse time and post data. if you do not have acces to php.ini on your server than just try to split your data and run different querrys for each table. once i have to split one table into 8 portions of data to insert all data from this one table only.