{"id":9193,"date":"2026-06-01T02:48:21","date_gmt":"2026-06-01T00:48:21","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=9193"},"modified":"2026-06-01T02:48:22","modified_gmt":"2026-06-01T00:48:22","slug":"cum-sa-modificati-codificarea-unei-baze-de-date-mysql","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-change-the-encoding-of-a-mysql-database\/","title":{"rendered":"Cum s\u0103 schimba\u021bi codificarea unei baze de date MySQL?"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">Codificarea caracterelor dintr-o baz\u0103 de date MySQL determin\u0103 modul \u00een care datele textuale sunt stocate \u0219i interpretate. Utilizarea codific\u0103rii corecte este important\u0103 pentru afi\u0219area corect\u0103 a caracterelor speciale, a semnelor diacritice \u0219i a con\u021binutului multilingv.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenainte de a efectua orice modificare, se recomand\u0103 insistent s\u0103 crea\u021bi o copie de rezerv\u0103 complet\u0103 a bazei de date.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Cuprins<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-change-the-encoding-of-a-mysql-database\/#Changing_the_database_encoding\">Modificarea codific\u0103rii bazei de date<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-change-the-encoding-of-a-mysql-database\/#Important_considerations\">Considera\u021bii importante<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/cum-se-modific\u0103-codificarea-unei-baze-de-date-MySQL\/#Crearea_unei_copii_de_rezerv\u0103_\u00eenainte_de_modific\u0103ri\">Crearea unei copii de rezerv\u0103 \u00eenainte de modific\u0103ri<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-change-the-encoding-of-a-mysql-database\/#Importing_data_with_a_specific_encoding\">Importarea datelor cu o codificare specific\u0103<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-to-change-the-encoding-of-a-mysql-database\/#Best_practices\">Cele mai bune practici<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/cum-se-modific\u0103-codificarea-unei-baze-de-date-MySQL\/#Rezumat\">Rezumat<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Modificarea_codific\u0103rii_bazei_de_date\"><\/span>Modificarea codific\u0103rii bazei de date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<\/div>\n\n<div id=\"mybox-4023201654\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">Pentru a modifica setul de caractere al unei baze de date existente, pute\u021bi utiliza comanda <code>ALTER DATABASE<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemplu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER DATABASE nume_bazei_de_date\nCHARACTER SET utf8mb4\nCOLLATE utf8mb4_unicode_ci;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Unde:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>database_name<\/code> \u2013 numele bazei de date<\/li>\n\n\n\n<li><code>utf8mb4<\/code> \u2013 setul de caractere care va fi utilizat<\/li>\n\n\n\n<li><code>utf8mb4_unicode_ci<\/code> \u2013 colarea asociat\u0103 setului de caractere selectat<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Setul de caractere <code>utf8mb4<\/code> este recomandat \u00een general, deoarece accept\u0103 \u00eentreaga gam\u0103 de caractere Unicode.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Important_considerations\"><\/span>Considera\u021bii importante<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Modificarea codific\u0103rii implicite a unei baze de date nu converte\u0219te automat codificarea tabelelor \u0219i coloanelor existente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen unele cazuri, pot fi necesare comenzi suplimentare pentru actualizarea:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>tabelele existente<\/li>\n\n\n\n<li>defini\u021biile coloanelor<\/li>\n\n\n\n<li>datele importate<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Neefectuarea unei conversii complete poate duce la afi\u0219area incorect\u0103 a caracterelor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_a_backup_before_changes\"><\/span>Crearea unei copii de rezerv\u0103 \u00eenainte de modific\u0103ri<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenainte de a modifica codificarea, crea\u021bi o copie de rezerv\u0103 a bazei de date:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u nume_utilizator -p nume_bazei_de_date &gt; backup.sql\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Acest lucru v\u0103 permite s\u0103 restaura\u021bi datele \u00een cazul \u00een care apar probleme \u00een timpul procesului de conversie.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Importarea_datelor_cu_o_codificare_specific\u0103\"><\/span>Importarea datelor cu o codificare specific\u0103<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">C\u00e2nd restaura\u021bi o baz\u0103 de date, pute\u021bi specifica setul de caractere \u00een timpul importului:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u nume_utilizator -p --default-character-set=utf8mb4 nume_bazei_de_date &lt; backup.sql\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenlocui\u021bi:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>username<\/code> cu utilizatorul dvs. MySQL<\/li>\n\n\n\n<li><code>database_name<\/code> cu numele bazei de date de destina\u021bie<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Best_practices\"><\/span>Cele mai bune practici<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenainte de a modifica codificarea:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>crea\u021bi o copie de rezerv\u0103 complet\u0103<\/li>\n\n\n\n<li>verifica\u021bi codificarea actual\u0103 a bazei de date<\/li>\n\n\n\n<li>verifica\u021bi codificarea tabelelor \u0219i a coloanelor<\/li>\n\n\n\n<li>testa\u021bi conversia pe o copie de dezvoltare, dac\u0103 este posibil<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Acest lucru ajut\u0103 la prevenirea corup\u021biei datelor \u0219i a problemelor de afi\u0219are a caracterelor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Rezumat<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pute\u021bi modifica codificarea implicit\u0103 a unei baze de date MySQL folosind comanda <code>ALTER DATABASE<\/code>. \u00cenainte de a efectua orice modificare, crea\u021bi o copie de rezerv\u0103 \u0219i verifica\u021bi dac\u0103 tabelele \u0219i coloanele sunt, de asemenea, configurate corect. Pentru majoritatea aplica\u021biilor moderne, setul de caractere <code>utf8mb4<\/code> este op\u021biunea recomandat\u0103.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[11462,11493,11501,11391,11490],"manual_kb_tag":[2153,5844,5845,5846,5847,5848,5849,5850,5851,5852],"class_list":["post-9193","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-database-performance-troubleshooting","manualknowledgebasecat-databases-sql","manualknowledgebasecat-mysql-mariadb","manualknowledgebasecat-databases-mysql","manualknowledgebasecat-developer-resources","manual_kb_tag-mysql-database","manual_kb_tag-database-encoding","manual_kb_tag-character-encoding","manual_kb_tag-character-set","manual_kb_tag-utf8mb","manual_kb_tag-utf8mb-collation","manual_kb_tag-database-collation","manual_kb_tag-change-database-encoding","manual_kb_tag-convert-table-encoding","manual_kb_tag-convert-column-encoding"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9193\/revisions"}],"predecessor-version":[{"id":9194,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9193\/revisions\/9194"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=9193"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=9193"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=9193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}