{"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":"aktualisierung-der-sortierreihenfolge-in-ihrer-mysql-datenbank-fur-verbesserte-funktionalitat","status":"publish","type":"ht_kb","link":"https:\/\/membermouse.com\/de\/docs\/aktualisierung-der-sortierreihenfolge-in-ihrer-mysql-datenbank-fur-verbesserte-funktionalitat\/","title":{"rendered":"Aktualisieren von Sortierreihenfolgen in Ihrer MySQL-Datenbank f\u00fcr verbesserte Funktionalit\u00e4t"},"content":{"rendered":"<p>Kollationierung bezieht sich auf die Regeln, die von einem Datenbanksystem wie MySQL verwendet werden, um Zeichenketten zu sortieren oder sie bei der Suche zu vergleichen. Diese Regeln bestimmen, wie Zeichen geordnet und verglichen werden, einschlie\u00dflich der Unterscheidung von Gro\u00df- und Kleinschreibung, Akzentzeichen und anderen sprachspezifischen Merkmalen. Eine veraltete Sortierung kann zu Problemen mit der Datengenauigkeit und der Kompatibilit\u00e4t zwischen verschiedenen Sprachen und Regionen f\u00fchren.<\/p>\n\n\n\n<p><br>Die Aktualisierung der Kollation Ihrer MySQL-Datenbank ist f\u00fcr die Gew\u00e4hrleistung einer optimalen Leistung unerl\u00e4\u00dflich, insbesondere wenn Sie mit internationalen Zeichens\u00e4tzen oder mehrsprachigen Anwendungen arbeiten. Eine moderne Kollation bietet bessere Unterst\u00fctzung f\u00fcr verschiedene Sprachmerkmale wie Akzentzeichen, Gro\u00df- und Kleinschreibung und diakritische Zeichen, die in der heutigen globalisierten Welt von entscheidender Bedeutung sind.<\/p>\n\n\n\n<p><br>Wenn MemberMouse 3.0 zum ersten Mal installiert wird, werden Sie aufgefordert, Ihre Datenbanktabellen zu aktualisieren. Auf dem Verwaltungsbildschirm, der angezeigt wird, wenn Sie auf die Aktualisierung Ihrer Datenbank klicken, um sie mit Version 3.0 kompatibel zu machen, gibt es eine vorgew\u00e4hlte Option, die es Ihnen erm\u00f6glicht, Ihre Datenbanksortierung als Teil des Prozesses automatisch zu aktualisieren, was jedoch mit dem L\u00f6schen des Aktivit\u00e4tsprotokolls einhergeht. F\u00fcr die meisten Kunden ist dies die richtige Wahl. F\u00fcr Kunden, die ihr Aktivit\u00e4tsprotokoll beibehalten m\u00f6chten, kann die Aktualisierung der Sortierung entweder von einem Entwickler oder Ihrem Hosting-Provider manuell durchgef\u00fchrt werden.<\/p>\n\n\n\n<p><br><strong>ANMERKUNG<\/strong>: Wenn der Datenbank-Upgrade-Prozess ausgef\u00fchrt wurde und die Option zum Upgrade der Sortierung gew\u00e4hlt wurde, m\u00fcssen die folgenden Skripte nicht ausgef\u00fchrt werden.<\/p>\n\n\n\n<p><br><strong>ANMERKUNG<\/strong>: Der Name Ihrer Datenbanktabellen kann je nach dem von Ihrem Hosting-Provider festgelegten \"WordPress-Datenbankpr\u00e4fix\" variieren. In den nachstehenden Skripten wurde das Pr\u00e4fix \"wp_\" verwendet, aber das kann in der Datenbank Ihrer Website anders sein. Stellen Sie vor der Ausf\u00fchrung des SQL-Skripts fest, welches Ihr Datenbankpr\u00e4fix ist (wenden Sie sich an Ihren Hosting-Provider, wenn Sie nicht sicher sind, wie das geht) und passen Sie die Tabellennamen gegebenenfalls an.<\/p>\n\n\n\n<p><br>Die folgenden SQL-Anweisungen k\u00f6nnen zur Aktualisierung der erforderlichen MemberMouse-Datenbanktabellen verwendet werden:<\/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_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>Je nach Konfiguration Ihrer Website k\u00f6nnen zus\u00e4tzliche Tabellen vorhanden sein. Die folgenden SQL-Anweisungen aktualisieren alle optionalen Datenbanktabellen, die in Ihrer Datenbank vorhanden sind.<\/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>Die Aktualisierung der Sortierreihenfolge Ihrer MySQL-Datenbank ist entscheidend f\u00fcr die Gew\u00e4hrleistung einer optimalen Leistung in der heutigen globalisierten Welt. Wenn Sie diese Schritte befolgen, k\u00f6nnen Sie problemlos auf eine modernere Sortierung umstellen, die internationale Zeichens\u00e4tze, mehrere Sprachen und Emojis besser unterst\u00fctzt.<\/p>","protected":false},"excerpt":{"rendered":"<p>Kollationierung bezieht sich auf den Satz von Regeln, die von einem Datenbanksystem wie MySQL verwendet werden, um Zeichenketten zu sortieren oder bei der Suche zu vergleichen. Diese Regeln bestimmen, wie die Zeichen angeordnet werden...<\/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\/de\/wp-json\/wp\/v2\/ht-kb\/17572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/users\/18796"}],"replies":[{"embeddable":true,"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/comments?post=17572"}],"version-history":[{"count":0,"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/ht-kb\/17572\/revisions"}],"wp:attachment":[{"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/media?parent=17572"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/ht-kb-category?post=17572"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/membermouse.com\/de\/wp-json\/wp\/v2\/ht-kb-tag?post=17572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}