[Summary view] [Print] [Text view]

   1  --
   2  -- This file contains the part of the UTF-8 Multibyte (utf8mb4) conversion for MySQL
   3  -- for optional extensions which might be still installed or not on an updated installation.
   4  --
   5  -- In opposite to file utf8mb4-conversion.sql, any table handled by this file here doesn't
   6  -- need to exist.
   7  --
   8  
   9  --
  10  -- Step 1: Convert all tables to utf8mb4 character set with utf8mb4_unicode_ci collation.
  11  --
  12  
  13  ALTER TABLE `#__core_log_searches` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  14  
  15  --
  16  -- Step 2: Set collation to utf8mb4_bin for formerly utf8_bin collated columns.
  17  --
  18  
  19  --
  20  -- Step 3: Set default character set and collation for all tables
  21  --
  22  
  23  ALTER TABLE `#__core_log_searches` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;