Jasig/uPortal — pull request #97 by raymondBourges (2012-12-06 15:02:50+00:00)
Title: Add MySQL 5 UTF-8 support

First excuse me for my poor English.

As said in UP-3254 issue to avoid MySQL error (Specified key was too long; max key length is 767 bytes) when using UTF-8 for i18n support you have to use innodb_large_prefix MySQL Option (innodb_large_prefix=true in my.cnf).

Additionally you have to use some other options (innodb_file_format=barracuda and innodb_file_per_table=true).

But you also have to give informations at the end of the SQL create command : “ENGINE=InnoDB ROW_FORMAT=COMPRESSED”.

By default, hybernate MySQL5InnoDBDialect just add “ENGINE=InnoDB”.

In this commit I create a specific dialect which extends MySQL5InnoDBDialect to have “ENGINE=InnoDB ROW_FORMAT=COMPRESSED”