CoreFiles by mySites.guru
utf8mb4-conversion_optional.sql23 lines, 743 bytes, from Joomla_4.0.0-beta1-Beta-Full_Package.zip
Raw History Compare with 3.9.0-beta4
md5
2acd0244fd5f9bca7663825bf8987ad5
sha1
0cdc74f02720d939b410a394fe26654db62ff6be
sha256
1960778904eba055d9a68b61b52b99a1883c4ce3f33ef33457d09085d39e0abc
--
-- This file contains the part of the UTF-8 Multibyte (utf8mb4) conversion for MySQL
-- for optional extensions which might be still installed or not on an updated installation.
--
-- In opposite to file utf8mb4-conversion.sql, any table handled by this file here doesn't
-- need to exist.
--

--
-- Step 1: Convert all tables to utf8mb4 chracter set with utf8mb4_unicode_ci collation.
--

ALTER TABLE `#__core_log_searches` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

--
-- Step 2: Set collation to utf8mb4_bin for formerly utf8_bin collated columns.
--

--
-- Step 3: Set default character set and collation for all tables
--

ALTER TABLE `#__core_log_searches` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

The same content is in 8 releases, Joomla 4.0.0-beta to 4.0.0-rc1. See them all, or every version of this file.