Joomla! International
Welcome, Guest
Please Login or Register.
Lost Password?
_GEN_GOTOBOTTOM Post Reply Favoured: 0
TOPIC: convert to utf-8 easy
#41
convert to utf-8 easy 2007/12/17 10:04  
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.
  The administrator has disabled public write access.
_GEN_GOTOTOP Post Reply
get the latest posts directly to your desktop