Joomla! Discussion Forums

Hello
in joomla 1.0.X series,database was latin1
and saved data same : U…?آ±Uئ’?آ² Uâ€،Uâ€

but in joomla 1.5 have change,and saved good data
for example U…?آ±Uئ’?آ² Uâ€،U†==> ُسلام.تست

how may i convert mysql to utf8?and solved charsets? and chars?

com_migrator,done this work
but is just for content,users and ...
but is not for fully database

Thanks

Hello Mostafa,

Just make a dump of the database choosing utf8 as encoding.
Then, to be sure, open the dump in an utf8 editor and check all is OK.

Hello jeans
thanks

i going to phpmyadmin,export joomla 1.0.x series database.
then i open this file into notepad++

and id not good

Thanks jean

Same problem here, how can I export as UTF-8?

Hello,

Simply ... export the tables with phpmyadmin in SQL format. Edit the .sql file with Wordpad (or other editor), replace "latin1" with "utf8" and save the file. Then, import the file with phpmyadmin...

@yamadix

thanx for the reply friend ... but there's a little problem ... my exported .sql backup from phpmyadmin doesn't show character sets for tables creation .. am i missing an option or so in phpmyadmin ??

Hello,

In the SQL-Export, for each table, you must find this line :


If no, I am sorry ... I don't have an other response !

all that i got is Type=MyISAM ... only. Anyway i'll give it a try with ENGINE=MyISAM DEFAULT CHARSET=latin1; instead of the Type may be it'll work

xenome, take in mind next SQL queries:
DB charset replacement: ALTER DATABASE `db_name` COLLATE utf8_general_ci
Table charset replacement: ALTER TABLE `table_name` COLLATE utf8_general_ci

Where db_name and table_name - you have to use the right data.

This WILL NOT work in Joomla 1.5.
1.5 is fully utf8.
The default charset does not need to be set in the dump if the database is correctly collated.