UTF8 et les émojis

Par Franck, . Lien permanent Brèves

Au passage, j’ai pu me rendre compte de certaines limitations de la base de données de mes blogues : sur Mastodon, j’utilise des emojis pour indiquer s’il s’agit d’un spectacle de danse (💃), d’un concert (🎤), de théâtre (🎭), etc. Toutefois, si ma base de données MySQL était bien configurée en utf8 lors de sa création, dans les faits cela correspond à utf8mb3 (UTF-8 codé sur trois octets), qui ne supporte pas les emojis. Mes tentatives de migration de la base à utf8mb4 (UTF-8 codé sur quatre octets) s’étant avérées désastreuses, j’ai donc crée une nouvelle base ayant dès le départ le bon format.

Julien Mudry, Bilan d’une semaine consacrée à Dotclear

J’avais codé rapidement un petit plugin pour pallier ce problème1, sauf qu’il est limité au contenu des billets et pages, extraits et corps, des commentaires et des notes des billets ; ça peut être insuffisant, par exemple si on veut utiliser des émojis (UTF8) dans les titres des billets.

J’ai testé ce matin un script SQL de conversion UTF8 vers UTF8 (mb4 + unicode_ci) mais sans réussir une connexion ensuite sur l’administration du blog avec la base convertie ; j’avoue ne pas avoir été plus loin dans la recherche de ce qui coince, ça sera pour plus tard.

En attendant je mets ici le script en question :

SET SESSION innodb_strict_mode=OFF, NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';
SET foreign_key_checks = 0;
ALTER DATABASE `open_time` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_category` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_comment` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_link` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_log` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_media` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_meta` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_notice` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_permissions` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_ping` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_post` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_post_media` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_pref` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_session` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_setting` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_spamrule` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_user` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_version` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_zc_feed` ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
ALTER TABLE `open_time`.`dc_blog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_category` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_meta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_ping` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post_media` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_session` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_spamrule` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_version` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` CHANGE `blog_uid` `blog_uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` CHANGE `blog_url` `blog_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` CHANGE `blog_name` `blog_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_category` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_category` CHANGE `cat_title` `cat_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_category` CHANGE `cat_url` `cat_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_tz` `comment_tz` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_author` `comment_author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_email` `comment_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_site` `comment_site` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_ip` `comment_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_spam_status` `comment_spam_status` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_spam_filter` `comment_spam_filter` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `link_href` `link_href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `link_title` `link_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `link_desc` `link_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `link_lang` `link_lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_link` CHANGE `link_xfn` `link_xfn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CHANGE `log_table` `log_table` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CHANGE `log_ip` `log_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `media_path` `media_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `media_title` `media_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `media_file` `media_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `media_dir` `media_dir` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_meta` CHANGE `meta_id` `meta_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_meta` CHANGE `meta_type` `meta_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CHANGE `ses_id` `ses_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CHANGE `notice_type` `notice_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CHANGE `notice_format` `notice_format` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_permissions` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_permissions` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_ping` CHANGE `ping_url` `ping_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_tz` `post_tz` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_password` `post_password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_type` `post_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_format` `post_format` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_url` `post_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_lang` `post_lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_title` `post_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post_media` CHANGE `link_type` `link_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `pref_id` `pref_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `pref_ws` `pref_ws` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `pref_type` `pref_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_session` CHANGE `ses_id` `ses_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `setting_id` `setting_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `setting_ns` `setting_ns` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `setting_type` `setting_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_spamrule` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_spamrule` CHANGE `rule_type` `rule_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_spamrule` CHANGE `rule_content` `rule_content` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_id` `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_pwd` `user_pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_recover_key` `user_recover_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_name` `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_firstname` `user_firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_displayname` `user_displayname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_email` `user_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_url` `user_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_default_blog` `user_default_blog` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_lang` `user_lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_tz` `user_tz` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_version` CHANGE `module` `module` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_version` CHANGE `version` `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_type` `feed_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `blog_id` `blog_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_name` `feed_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_url` `feed_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_feed` `feed_feed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_tags` `feed_tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_owner` `feed_owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_tweeter` `feed_tweeter` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_lang` `feed_lang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_blog` CHANGE `blog_desc` `blog_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_category` CHANGE `cat_desc` `cat_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_content` `comment_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_comment` CHANGE `comment_words` `comment_words` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_log` CHANGE `log_msg` `log_msg` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_media` CHANGE `media_meta` `media_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CHANGE `notice_msg` `notice_msg` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_notice` CHANGE `notice_options` `notice_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_permissions` CHANGE `permissions` `permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_excerpt` `post_excerpt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_excerpt_xhtml` `post_excerpt_xhtml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_content` `post_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_content_xhtml` `post_content_xhtml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_notes` `post_notes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_words` `post_words` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_post` CHANGE `post_meta` `post_meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `pref_value` `pref_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_pref` CHANGE `pref_label` `pref_label` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_session` CHANGE `ses_value` `ses_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `setting_value` `setting_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_setting` CHANGE `setting_label` `setting_label` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_desc` `user_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_user` CHANGE `user_options` `user_options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `open_time`.`dc_zc_feed` CHANGE `feed_desc` `feed_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
SET foreign_key_checks = 1;

Ça fonctionne plutôt pas mal, une fois que les quelques clés dupliquées sont éradiquées, en particulier, chez moi, sur les URLs de certains billets des planets ; va falloir que je fasse un peu de ménage/nettoyage de ce côté avant de reprendre…

Bref, WIP comme on dit :-)

  1. D’ailleurs les émojis présents dans la citation de Julien sont correctement enregistrés et affichés bien que ma base de données actuelle soit encore en UTF8 standard (mb3). ↩︎

Ajouter un commentaire

Les champs suivis d'un * sont obligatoires

Les commentaires peuvent être formatés en utilisant la syntaxe Markdown Extra.

Ajouter un rétrolien

URL de rétrolien : https://open-time.net/trackback/15579

Haut de page