Using MySql with Jahia on Debian GNU/Linux

Using MySql with Jahia on Debian GNU/Linux

Oct 30
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

Posted by Junior B. 2

2 comments

  1. Sergiy Shyrkov
    Posted on 2 November 2009

    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.

  2. prinitha
    Posted on 24 August 2010

    thank you soo much!!!!

Leave a Reply