mt-site Files · sql/001-convert-to-utf8.sql

Add SQL script to convert all tables to proper UTF8 encoding.

darkmorford - - Load All Authors

File last commit:

93781bf7b1d9

93781bf7b1d9

Download file

             001-convert-to-utf8.sql
        
                    23 lines
            
             | 1.9 KiB
            
                | text/x-sql
            
             |
                SqlLexer
            
             / sql / 001-convert-to-utf8.sql
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content

     darkmorford
  
Add SQL script to convert all tables to proper UTF8 encoding.

              r19
            
      ALTER TABLE `actor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `admin_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `admin_section` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `banner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `contributor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `fredart` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `media_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `meta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `meta_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `rant` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `rant_attachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `rss_comment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `scratchpad` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `sponsor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `static_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `strip` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `strip_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `support` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `transcript` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `twitter_post` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `twitter_status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

      ALTER TABLE `twitter_user` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings

darkmorford Add SQL script to convert all tables to proper UTF8 encoding.	r19	ALTER TABLE `actor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `admin_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `admin_section` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `banner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `contributor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `fredart` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `media_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `meta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `meta_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `rant` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `rant_attachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `rss_comment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `scratchpad` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `sponsor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `static_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `strip` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `strip_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `support` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `transcript` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `twitter_post` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `twitter_status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
		ALTER TABLE `twitter_user` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;