{"id":17572,"date":"2024-02-06T16:56:22","date_gmt":"2024-02-06T21:56:22","guid":{"rendered":"https:\/\/membermouse.com\/?post_type=ht_kb&#038;p=17572"},"modified":"2024-04-29T17:16:50","modified_gmt":"2024-04-29T21:16:50","slug":"actualizacion-de-las-intercalaciones-en-su-base-de-datos-mysql-para-mejorar-la-funcionalidad","status":"publish","type":"ht_kb","link":"https:\/\/membermouse.com\/es\/docs\/actualizacion-de-las-intercalaciones-en-su-base-de-datos-mysql-para-mejorar-la-funcionalidad\/","title":{"rendered":"Actualizaci\u00f3n de las colaciones en su base de datos MySQL para mejorar su funcionalidad"},"content":{"rendered":"<p>La intercalaci\u00f3n se refiere al conjunto de reglas utilizadas por un sistema de base de datos como MySQL para ordenar cadenas de caracteres o compararlas al realizar b\u00fasquedas. Estas reglas determinan c\u00f3mo se ordenan y comparan los caracteres, incluyendo la distinci\u00f3n entre may\u00fasculas y min\u00fasculas, las tildes y otras caracter\u00edsticas espec\u00edficas del idioma. Tener una intercalaci\u00f3n obsoleta puede provocar problemas con la precisi\u00f3n de los datos y la compatibilidad entre distintos idiomas y regiones.<\/p>\n\n\n\n<p><br>Actualizar la intercalaci\u00f3n de su base de datos MySQL es esencial para garantizar un rendimiento \u00f3ptimo, especialmente cuando se trabaja con conjuntos de caracteres internacionales o aplicaciones multiling\u00fces. Una intercalaci\u00f3n moderna proporciona un mejor soporte para varias caracter\u00edsticas ling\u00fc\u00edsticas, como marcas de acento, insensibilidad a may\u00fasculas y min\u00fasculas y diacr\u00edticos, que son cruciales en el mundo globalizado de hoy.<\/p>\n\n\n\n<p><br>Al instalar MemberMouse 3.0 por primera vez, se le pedir\u00e1 que actualice las tablas de su base de datos. En la pantalla de administraci\u00f3n que aparece al hacer clic para actualizar la base de datos y hacerla compatible con la versi\u00f3n 3.0, hay una opci\u00f3n preseleccionada que le permitir\u00e1 actualizar autom\u00e1ticamente la intercalaci\u00f3n de la base de datos como parte del proceso, a expensas de borrar el registro de actividades. Para la mayor\u00eda de los clientes, \u00e9sta es la opci\u00f3n correcta. Para los clientes que deseen conservar su registro de actividad, la actualizaci\u00f3n de la intercalaci\u00f3n puede ser realizada manualmente por un desarrollador o por su proveedor de alojamiento.<\/p>\n\n\n\n<p><br><strong>NOTA<\/strong>: Si se ha ejecutado el proceso de actualizaci\u00f3n de la base de datos y se ha seleccionado la opci\u00f3n de actualizar la intercalaci\u00f3n, no es necesario ejecutar las siguientes secuencias de comandos.<\/p>\n\n\n\n<p><br><strong>NOTA<\/strong>: El nombre de las tablas de su base de datos puede variar en funci\u00f3n del \"prefijo de la base de datos de WordPress\" establecido por su proveedor de alojamiento. En los scripts que se muestran a continuaci\u00f3n, se ha utilizado el prefijo \"wp_\", pero \u00e9ste puede variar en la base de datos de su sitio. Antes de ejecutar el SQL, determine cu\u00e1l es el prefijo de su base de datos (contacte con su proveedor de alojamiento si no est\u00e1 seguro de c\u00f3mo hacerlo) y ajuste los nombres de las tablas si es necesario.<\/p>\n\n\n\n<p><br>Las siguientes sentencias SQL pueden utilizarse para actualizar las tablas necesarias de la base de datos MemberMouse:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>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_bundle_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<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Dependiendo de la configuraci\u00f3n de su sitio, puede haber tablas adicionales. Las siguientes sentencias SQL actualizar\u00e1n cualquier tabla de base de datos opcional que exista en su base de datos.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>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<p>Actualizar la intercalaci\u00f3n de su base de datos MySQL es crucial para garantizar un rendimiento \u00f3ptimo en el mundo globalizado de hoy en d\u00eda. Siguiendo estos pasos, puede cambiar f\u00e1cilmente a una intercalaci\u00f3n m\u00e1s moderna que admita mejor conjuntos de caracteres internacionales, varios idiomas y emojis.<\/p>","protected":false},"excerpt":{"rendered":"<p>La intercalaci\u00f3n se refiere al conjunto de reglas utilizadas por un sistema de base de datos como MySQL para ordenar cadenas de caracteres o compararlas al realizar b\u00fasquedas. Estas reglas determinan c\u00f3mo se ordenan los caracteres...<\/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\/es\/wp-json\/wp\/v2\/ht-kb\/17572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/users\/18796"}],"replies":[{"embeddable":true,"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/comments?post=17572"}],"version-history":[{"count":0,"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/ht-kb\/17572\/revisions"}],"wp:attachment":[{"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/media?parent=17572"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/ht-kb-category?post=17572"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/membermouse.com\/es\/wp-json\/wp\/v2\/ht-kb-tag?post=17572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}