Public Forums 71,145 posts

[mambolearn Friend mambolearnJoin date: January 2006Posts: 36Downloads:0Uploads:3 Thanks: 10 Thanked: 8 times in 1 posts]

#142687

Hi

I am migrating from joomla 1.0.15 to 1.5.11 and I want to migrate my JoomlaComment contents.

The version on Joomla 1.0.15 was 3.1.1 and the one on Joomla 1.5.11 is 3.26

I exported from the old table jos_comment and imported it in new database (joomla 1.5) and then I installed the 3.26 on new joomla so it was imported good.

But the problem is my language which is utf-8 and now the characters are in mess.

I changed the collation to utf-8 but it didn’t change.

I should mention that I don’t have problem for writing new comments, my problem is my old comments. I need them 🙁

in the old database the collation is latin1_swedish_ci and the characters are not readable in phpmyadmin but the comments are readable in my site and joomla administration.

I changed them to utf8_general_ci and then exported the table but the problem exists.

Thanks

is there any help?

[mambolearn Friend mambolearnJoin date: January 2006Posts: 36Downloads:0Uploads:3 Thanks: 10 Thanked: 8 times in 1 posts]

#310749

Hi all

my problem got solved.

I write this for the ones who may have the same problem.

just used the attached script for converting the database collation.

Regards

---

Attachments:

1. 111.zip

[Author]

Posts