Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql =================================================================== diff -u -r0ce4c64de6f6fbf1eaea18a62b89143d2fa05fe0 -rd1f3f4b3b7a4b6cabd7ab5da8e703e648c762890 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql (.../patch2040052.sql) (revision 0ce4c64de6f6fbf1eaea18a62b89143d2fa05fe0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql (.../patch2040052.sql) (revision d1f3f4b3b7a4b6cabd7ab5da8e703e648c762890) @@ -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;