CoreFiles by mySites.guru
utf8mb4-conversion_optional.sql23 lines, 744 bytes, from Joomla_4.2.4-Stable-Full_Package.zip
Raw History Compare with 4.2.3
md5
353c7684ff966a0ab6ea15403ce6c32e
sha1
27e7de30fdabd57f69f1f17e7f6e9afbf5c0738e
sha256
f4e65da378f362294d401fc0e6b4be6bc3e6ae8576cbda45958b9ec43ed5f935
--
-- 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 character 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 123 releases, Joomla 4.0.0-rc2 to 4.4.14. See them all, or every version of this file.