{"id":17572,"date":"2024-02-06T16:56:22","date_gmt":"2024-02-06T21:56:22","guid":{"rendered":"https:\/\/membermouse.com\/?post_type=ht_kb&p=17572"},"modified":"2024-04-29T17:16:50","modified_gmt":"2024-04-29T21:16:50","slug":"mise-a-niveau-des-collations-dans-votre-base-de-donnees-mysql-pour-une-meilleure-fonctionnalite","status":"publish","type":"ht_kb","link":"https:\/\/membermouse.com\/fr\/documents-3-2\/mise-a-niveau-des-collations-dans-votre-base-de-donnees-mysql-pour-une-meilleure-fonctionnalite\/","title":{"rendered":"Mise \u00e0 jour des collations dans votre base de donn\u00e9es MySQL pour une meilleure fonctionnalit\u00e9"},"content":{"rendered":"

La collation fait r\u00e9f\u00e9rence \u00e0 l'ensemble des r\u00e8gles utilis\u00e9es par un syst\u00e8me de base de donn\u00e9es comme MySQL pour trier les cha\u00eenes de caract\u00e8res ou les comparer lors d'une recherche. Ces r\u00e8gles d\u00e9terminent la mani\u00e8re dont les caract\u00e8res sont ordonn\u00e9s et compar\u00e9s, y compris la sensibilit\u00e9 \u00e0 la casse, les accents et d'autres caract\u00e9ristiques propres \u00e0 la langue. Une collation obsol\u00e8te peut entra\u00eener des probl\u00e8mes de pr\u00e9cision des donn\u00e9es et de compatibilit\u00e9 entre les diff\u00e9rentes langues et r\u00e9gions.<\/p>\n\n\n\n


La mise \u00e0 jour de la collation de votre base de donn\u00e9es MySQL est essentielle pour garantir des performances optimales, en particulier lorsque vous travaillez avec des jeux de caract\u00e8res internationaux ou des applications multilingues. Une collation moderne offre une meilleure prise en charge de diverses caract\u00e9ristiques linguistiques, telles que les accents, l'insensibilit\u00e9 \u00e0 la casse et les diacritiques, qui sont cruciales dans le monde globalis\u00e9 d'aujourd'hui.<\/p>\n\n\n\n


Lors de la premi\u00e8re installation de MemberMouse 3.0, vous serez invit\u00e9 \u00e0 mettre \u00e0 niveau les tables de votre base de donn\u00e9es. Sur l'\u00e9cran d'administration qui s'affiche lorsque vous cliquez sur la mise \u00e0 niveau de votre base de donn\u00e9es pour la rendre compatible avec la version 3.0, une option pr\u00e9s\u00e9lectionn\u00e9e vous permet de mettre automatiquement \u00e0 niveau la collation de votre base de donn\u00e9es dans le cadre du processus, au prix de l'effacement du journal d'activit\u00e9. Pour la plupart des clients, c'est le bon choix. Pour les clients qui souhaitent conserver leur journal d'activit\u00e9, la mise \u00e0 niveau du collationnement peut \u00eatre effectu\u00e9e manuellement par un d\u00e9veloppeur ou par votre fournisseur d'h\u00e9bergement.<\/p>\n\n\n\n


NOTE<\/strong>: Si le processus de mise \u00e0 niveau de la base de donn\u00e9es a \u00e9t\u00e9 ex\u00e9cut\u00e9 et que l'option de mise \u00e0 niveau de la collation a \u00e9t\u00e9 s\u00e9lectionn\u00e9e, il n'est pas n\u00e9cessaire d'ex\u00e9cuter les scripts suivants.<\/p>\n\n\n\n


NOTE<\/strong>: Le nom des tables de votre base de donn\u00e9es peut varier en fonction du \"pr\u00e9fixe de la base de donn\u00e9es WordPress\" d\u00e9fini par votre h\u00e9bergeur. Dans les scripts ci-dessous, le pr\u00e9fixe \"wp_\" a \u00e9t\u00e9 utilis\u00e9, mais il peut \u00eatre diff\u00e9rent dans la base de donn\u00e9es de votre site. Avant d'ex\u00e9cuter le code SQL, d\u00e9terminez le pr\u00e9fixe de votre base de donn\u00e9es (contactez votre h\u00e9bergeur si vous n'\u00eates pas s\u00fbr de savoir comment faire) et ajustez les noms des tables si n\u00e9cessaire.<\/p>\n\n\n\n


Les instructions SQL suivantes peuvent \u00eatre utilis\u00e9es pour mettre \u00e0 jour les tables requises de la base de donn\u00e9es MemberMouse :<\/p>\n\n\n\n

ALTER TABLE `wp_mm_actions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_affiliate_partner_payouts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_affiliate_provider_mappings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_affiliate_providers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_affiliate_rebill_commissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_api_keys` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_applied_bundles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_bundle_categories` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_bundle_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_bundles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_card_on_file` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_commission_profiles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_core_page_types` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_core_pages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_countries` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_country_subdivisions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coupon_restrictions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coupon_usage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coupons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_custom_field_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_custom_field_options` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_custom_fields` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_diagnostic_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_email_provider_bundle_mappings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_email_provider_mappings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_email_service_providers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_employee_accounts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_flatrate_shipping_options` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_log_captcha` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_log_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_login_token` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_membership_level_categories` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_membership_level_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_membership_levels` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_order_item_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_order_items` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_orders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_payment_services` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_posts_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_queued_scheduled_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_report_data_cache` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_scheduled_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_scheduled_payments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_sessions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_shipping_methods` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_smarttag_groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_smarttags` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_social_login_linked_profiles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_social_login_providers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_top_level_domains` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_transaction_key` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_transaction_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_user_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_user_defined_pages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_version_releases` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\n\n<\/code><\/pre>\n\n\n\n
\n\n\n\n
Selon la configuration de votre site, des tables suppl\u00e9mentaires peuvent \u00eatre pr\u00e9sentes. Les instructions SQL suivantes mettront \u00e0 jour toutes les tables optionnelles qui existent dans votre base de donn\u00e9es.<\/p>\n\n\n\n
<\/p>\n\n\n\n
ALTER TABLE `wp_mm_authorizenet_aim_transactions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_authorizenet_arb_subscriptions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_authorizenet_arb_subscription_history` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_authorizenet_pending_overdue_subscriptions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_paypal_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_paypal_subscr_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbase_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbase_subscr_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbase_button_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbaseminimal_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbaseminimal_button_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbaseminimal_scheduled_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_coinbaseminimal_transactions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_customer_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_charges` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_memberships` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_subscription_payments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_webhooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stripe_coupons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_clickbank_product_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_clickbank_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_clickbank_order_item_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_braintree_customer_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_braintree_charges` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_authorizenet_cim_customer_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_authorizenet_cim_charges` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_limelight_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_limelight_shipping_methods` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_limelight_subscription_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_limelight_charges` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_limelight_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stickyio_products` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stickyio_shipping_methods` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stickyio_subscription_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stickyio_charges` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_stickyio_ipn_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_test_cardonfile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;\nALTER TABLE `wp_mm_scheduled_payment_job_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ;<\/code><\/pre>\n\n\n\n
La mise \u00e0 jour de la collation de votre base de donn\u00e9es MySQL est essentielle pour garantir des performances optimales dans le monde globalis\u00e9 d'aujourd'hui. En suivant ces \u00e9tapes, vous pouvez facilement passer \u00e0 une collation plus moderne qui prend mieux en charge les jeux de caract\u00e8res internationaux, les langues multiples et les emojis.<\/p>","protected":false},"excerpt":{"rendered":"
La collation d\u00e9signe l'ensemble des r\u00e8gles utilis\u00e9es par un syst\u00e8me de base de donn\u00e9es tel que MySQL pour trier les cha\u00eenes de caract\u00e8res ou les comparer lors d'une recherche. Ces r\u00e8gles d\u00e9terminent l'ordre des caract\u00e8res...<\/p>","protected":false},"author":18796,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"_strive_editorial_status":"not-started","_strive_copy_of":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"ht-kb-category":[135],"ht-kb-tag":[],"class_list":["post-17572","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-install-upgrade-plugin"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/ht-kb\/17572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/users\/18796"}],"replies":[{"embeddable":true,"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/comments?post=17572"}],"version-history":[{"count":0,"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/ht-kb\/17572\/revisions"}],"wp:attachment":[{"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/media?parent=17572"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/ht-kb-category?post=17572"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/membermouse.com\/fr\/wp-json\/wp\/v2\/ht-kb-tag?post=17572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}