Add SQL script to convert all tables to proper UTF8 encoding.
darkmorford -
93781bf7b1d9
Not Reviewed
Show More
Add another comment
TODOs: 0 unresolved 0 Resolved
COMMENTS: 0 General 0 Inline
@@ -0,0 +1,23
1 ALTER TABLE `actor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
2 ALTER TABLE `admin_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
3 ALTER TABLE `admin_section` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
4 ALTER TABLE `banner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
5 ALTER TABLE `contributor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
6 ALTER TABLE `fredart` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
7 ALTER TABLE `media_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
8 ALTER TABLE `meta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
9 ALTER TABLE `meta_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
10 ALTER TABLE `rant` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
11 ALTER TABLE `rant_attachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
12 ALTER TABLE `rss_comment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
13 ALTER TABLE `scratchpad` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
14 ALTER TABLE `sponsor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
15 ALTER TABLE `static_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
16 ALTER TABLE `status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
17 ALTER TABLE `strip` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
18 ALTER TABLE `strip_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
19 ALTER TABLE `support` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
20 ALTER TABLE `transcript` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
21 ALTER TABLE `twitter_post` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
22 ALTER TABLE `twitter_status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
23 ALTER TABLE `twitter_user` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Comments 0
You need to be logged in to leave comments. Login now