View Issue Detail

ID	Project	Category	Submitted / Last Updated
00929	UserSpice	Misc	2020-07-09 23:05:57 / 2020-07-10 20:07:45
Reported	Brandin Arsenault	Assigned To	Unassigned
Priority	low	Reported	5.1.3
Status	closed fixed	Resolution Version and Commit	5.1.4
Summary	Consider switching to utf8mb4_general_ci
Description	<p>utf8mb4_general_ci is for, the most part, a new standard and would allow emojis and special characters by default and allow consistency in our database. Consider changing all tables to this.</p> <p> </p> <p>sql_statements</p> <p>ALTER TABLE `us_user_sessions` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_saas_orgs` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_saas_levels` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_plugin_hooks` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_plugins` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_management` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_ip_whitelist` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_ip_list` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_ip_blacklist` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_form_views` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_form_validation` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_forms` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_fingerprint_assets` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_fingerprints` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `us_announcements` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `user_permission_matches` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `users_session` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `users_online` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `users` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `updates` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `settings` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `profiles` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `permission_page_matches` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `permissions` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `pages` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `notifications` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `message_threads` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `messages` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `menus` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `logs_exempt` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `logs` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `keys` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `groups_menus` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `email` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `crons_logs` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `crons` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p>ALTER TABLE `audit` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;</p> <p> </p>

November 2021

<p>https://pastebin.com/xve2XJ2b</p>
November 2021

<p>New installs will have this</p>