Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch2040052.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql 18 Dec 2015 04:40:32 -0000 1.1.2.2 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql 19 Feb 2016 16:09:29 -0000 1.1.2.3 @@ -5,8 +5,9 @@ -- LDEV-3629 Use 4 bytes Unicode characters in the whole DB --- Alter character set and encoding of the database and each table. Limit indexed text fields' length. -ALTER DATABASE lams CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; +-- Alter character set and encoding of the each table. +-- The database char set needs to be altered manually as at this point we do not know its name. +-- Limit indexed text fields' length. ALTER TABLE lams_activity_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE lams_activity_evaluation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;