After installing Jahia today, I wanted to use the MySql database instead of the default HyperSonic.
I am currently using MySql for other purposes and want to have a look at accessing the Jahia database to re-use content.
Initially when I created the ‘jahia’ database in mysql and granted permissions to the Jahia user, Jahia reported:
"This database doesn't seem to support extended charsets."
Dropping the database and recreating it with a unicode dataset sorts this little niggle out.
mysql> create database jahia character set = utf8;