Wrong UTF8

Wrong UTF8

by Mateo Byler -
Number of replies: 2
Hello,
I have Moodle 1.8.5 installed, and was thinking of upgrading.

But:
Under server environment, I see unicode is not active.

I would like to know what I can do in my situation.
How to migrate UTF-, unicode?

In phpMyAdmin I see some tables as "utf8_spanish_ci".
I assume these are the ones that though they are UTF8, should be instead "utf8_unicode_ci".

I guess my situation isnt as bad, as it does appear to have utf8, just spanish instead of unicode. What should I do?
And please, how?

Thanks.
Average of ratings: -
In reply to Mateo Byler

Re: Wrong UTF8

by Brian Lockwood -
I had a rogue table in mahara that was in the wrong character set and I did the following successfully

1) Check the default for mysql was utf8

2) Put server into admin mode.

3) Back up database

4) restore the database

5) put server back on line.


Average of ratings: -
In reply to Mateo Byler

Re: Wrong UTF8

by Mateo Byler -
I just finished upgrading a few minutes ago.

First I changed the collation for the database through phpMyAdmin.
Tables still showed as in old collates, so I individually changed each of them one at a time.

Example:
ALTER TABLE `mdl_message` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
Upgraded after that.
So far everything seems correct. Hopefully no side effects.
Thanks.

Average of ratings: -