What is not at all obvious about this is that the front page of myPHPadmin gives the localhost settings as... MySQL connection collation: utf8_general_ci
So you would be forgiven for thinking that it would be the default for all future tables, but as you pointed out, you seem to change the default settings in Operations! Its odd too that the install doesn't specify this its CREATE TABLE commands. Perhaps that would have the potential to upset other parallel databases. It is also true that some of the other solutions above, such as specifying this in a CREATE DATABASE command, would work if it were not that on a shared server you may be blocked from using this command.
Well, at least that's sorted!
]]>Next, I clicked on the tab, Operations. At the bottom, I changed the Collation from latin1_general_ci to utf8_general_ci. Next, clicked Go.
I navigated back to the page that stated "You are not using a UTF-8 database. Mahara stores all data as UTF-8 internally. Please drop and re-create your database using UTF-8 encoding" and refreshed it. I was able to proceed with the installation.
]]>
.Any other suggestions. ?
]]>Thanks
CREATE DATABASE mahara DEFAULT CHARACTER SET utf8;
]]>Create your mysql database with your usual procedure, dump the mysql database then open the mysql dump file using Notepad2 or something similar. If you are using notepad2 click on save and go to encoding within the file menu and select UTF-8 then click Save to overwrite the file.
Once saved with the UTF-8 encoding, restore this mysql dump and try the Mahara install again. This worked for me using notepad2 by the way.
Hope it helps,
Ali
]]>I have seen other posts about this problem, but I could not find the solution:
Despite having set my mysql db with an encoding utf8_general_ci can not seem to overcome the error message:
You are not using a UTF-8 database. Mahara stores all data as UTF-8 internally. Please drop and re-create your database using UTF-8 encoding.
where error
thanks for your attention