Using MySql with Jahia on Debian GNU/Linux

ottobre 30 1 Comment Category: Tech

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

  • Facebook
  • Delicious
  • LinkedIn
  • Yahoo Bookmarks
  • Twitter
  • MySpace
  • Diigo
  • Share/Bookmark

One Response

Write a comment
  1. 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.

    Sergiy Shyrkov 2 novembre 2009 at 15:57 Permalink

Write a Comment

Commenter Gravatar