HI,

I am a newbie in XOOPS.

One of my client suggest to setup an intranet site using XOOPS. In the past they have a very bad experience with another CMS using MyISAM(performance, crash...), so they prefer to have InnoDB in XOOPS.

I would like to know is there any success story with XOOPS + InnoDB? Any documents? Procedures? And any drawback(e.g. indexing)?

Just one more question, is it possible to configure XOOPS to use UTF-8(web output, MySQL storage entirely)?

Thank you very much.

Using InnoDB, I don't know. If it's close to MySQL syntax, it should be possible. It would require adding to the class/database/ class files, and going through the modules to see if they need changing as well.

About UTF-8, it is possible. What you need to do is save the install, language and *.sql files as UTF-8, and then do a clean install. That way, all data entered into the db will be UTF-8, and the database will handle that correctly. I've tried it and it works. However, it's not UTF-8 by default yet, so keep that in mind for updates and modules and such. We will probably try to move it to UFT-8 tho. The problem is how to migrate existing data...

Herko

innoDB is a MySQL table type, not another database.

AFAIK the syntax is the same, innoDB just accepting more SQL statements like lock tables etc.

thanks guys. I think I will give it a try.
may post here if found any compatibility problems.