I have a database, some of its data is in hebrew, and I see those symbols..
בדיקות ×™×“× ×™×•×ª בדיקות ×™×“× ×™×•×ª
Is there a way to configure the database so I wont see those symbols?!??
Chrome , as opposed to firefox, also displays those weird symbols.. weird squares
To change the character set encoding to UTF-8 for the database itself, type the following command at the mysql> prompt. Replace dbname with the database name: Copy ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci; To exit the mysql program, type \q at the mysql> prompt.
To solve the problem open the exported SQL file, search and replace the utf8mb4 with utf8 , after that search and replace the utf8mb4_unicode_520_ci with utf8_general_ci . Save the file and import it into your database. After that, change the wp-config. php charset option to utf8 , and the magic starts.
Click on the table you wish to modify. Inside the table, you will see a list of columns. To the right of the column name, you will see a link called "Change" under the Actions. Click on the Change link for the column you wish to modify.
Similarly, here's the command to change character set of MySQL table from latin1 to UTF8. Replace table_name with your database table name. mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; Hopefully, the above tutorial will help you change database character set to utf8mb4 (UTF-8).
From a command line:
ALTER TABLE table_name CONVERT TO CHARACTER SET charset_name;
Otherwise from phpmyadmin you could export and then import the database while changing the encoding. When you export it, at the end of the file you'll see something like CHARSET=hebrew_general_ci; Just replace it with whatever you need (e.g. CHARSET=utf8 or CHARSET=latin1_general_ci)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With