utf-8 and Collation on phpmyadmin

[Matador]

I've installed Mambo 4.6.3 and inserted content from Joomla! (just 4 tables), and although the install said utf-8 when I browse phpmyadmin I see that ALL the 38 tables have Collation set as "latin1_swedish_ci". The site is written in a non-english language.

So... is it bad?

Do I need to change all the tables to utf-8 (utf8_general_ci)?

How do I do it?

Thanks,

[neo_fox]

Hi Matador,

ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

unfortunately for every single table

Regards,
Neo

[Matador]

Thanks.

What if the old content wasn't utf-8? Does it care?

[neo_fox]

I never tried but is should be converted: http://dev.mysql.com/doc/refman/5.0/...t-convert.html

Regards,
Neo

[Matador]

Ouch! I get this error:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

[neo_fox]

This
ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; was of course just a placeholder for the real table name like: mos_bannerfinish, mos_categories, mos_comment, etc

[Matador]

Sorry. I'm a moron. I didn't change the word "TABLE".

[Matador]

Originally Posted by neo_fox

I never tried but is should be converted: http://dev.mysql.com/doc/refman/5.0/...t-convert.html

Regards,
Neo

Do I convert/cast before the table change? or after?

[Matador]

I've changed the tables but the SUM at the bottom keeps saying "latin1_swedish_ci", like the Database Collation.

[andphe]

Just a clue on this one, the charset used for the mysql connection is determined by charset of your language package, but additionally Mambo is able to use the mysql convertion so you can have your language package in a charset (utf-8 by default) and your database in another charset, doesn't work your mambo in that way?