Using MySql with Jahia on Debian GNU/Linux
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;
source: cuasan.wordpress.com
Yes, you are right
Jahia requires Unicode support on the DBMS level to correctly handle all the cases of the internationalization and multilingual support. That is why there is a special check during the installation process to assure the DB schema is created using UTF-8 character set.