How to change table collation in phpMyAdmin? - changing table with steps
@ Hey everybody, please help me, I'm a newbie, I have an account on my web host United States, and then install wordpress via Fantastico. Then I installed and activated the plugin Language Switcher. I can not send messages in Russian or Korean, all are displayed as ????. This is because the top of the table is set. It is currently set latin1_swedish_ci. When I think of phpmyadmin in cPanel account, then search the database for WordPress, especially the collection of paintings, I see. Solution has the answer: "If you select all the tables and then perform operations that change what the game needs characters in UTF-8, probably unique." I do not know exactly what I do and what I need to change and where. Can I change money
latin1_swedish_ci
in
utf8_general_ci
And if I want to publish the text, Russian and Korean on my Wordpress site? What should I do? Please respond when he does execute a person for each step. Thank you! I need you guys!
Friday, January 1, 2010
Changing Table With Steps How To Change Table Collation In PhpMyAdmin?
Subscribe to:
Post Comments (Atom)
It's a bit boring, but if you follow with phpMyAdmin before:
ReplyDelete1. Find your database in the left frame and click on it. The information contained in the database should now be the main (right side) of the framework and under the left should change to a list of all tables.
2. Click on a table in the left frame. This time, should receive the information in the table in the main window with a list of fields or columns. Otherwise, click on the "structure" tab in the main frame.
3. Click "Check All" under the list of fields and all fields of the table must be checked.
4. Click "Change Icon", which resembles a pen to the right to "certain".
5. Now you are with a form, you can present to change the selected fields. What interests us is the snack ") line. Utf_general_ci Change classification for (only for people with existing classification. Once the process finishes, click on" Save. "
6. Repeat steps 2-5 for each of his paintings.
This is with phpMyAdmin 3.1.1, theWay.