Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below:<\/p>\n
<\/p>\n
1. Enter your cPanel <\/strong>and click on the phpMyAdmin<\/strong> <\/strong>icon in the Databases box. <\/p>\n 3. Click on the Operations<\/strong> tab in the top menu of your phpMyAdmin<\/p>\n <\/p>\n 4. \u00a0At the bottom of the page you will see the collation <\/strong>option. You can now select a collation from the drop down menu and click on the Go<\/strong> button. Usually you will be interested in changing your MySQL collation in order to solve problems with foreign character encodings. The most common case is to change your MySQL collation from latin1 to utf8. This can be done by using phpMyAdmin and following the instructions below: 1. Enter your cPanel and click on the phpMyAdmin […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[57,56],"tags":[146,145,58],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-mysql","category-phpmyadmin","tag-mysql","tag-phpmyadmin","tag-utf-8"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9Yxzd-3p","jetpack-related-posts":[{"id":51,"url":"https:\/\/hosting-marketers.com\/news\/2007\/07\/19\/using-mysql-in-a-hosting-environment\/","url_meta":{"origin":211,"position":0},"title":"Using MySQL in a Hosting Environment","author":"Admin","date":"July 19, 2007","format":false,"excerpt":"Most of you know that MySQL is a database server that is heavy-duty.\u00c2\u00a0 It can be used with PHP and other assorted software languages and is a part of the family known as LAMP which stands for Linux, Apache, MySQL, and PHP. Hosting Marketers supports on its cpanel, MYSQL and\u2026","rel":"","context":"In "Hosting Marketers News"","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":475,"url":"https:\/\/hosting-marketers.com\/news\/2014\/05\/12\/how-do-you-recover-joomla-admin-password\/","url_meta":{"origin":211,"position":1},"title":"How do you recover joomla admin password","author":"Admin","date":"May 12, 2014","format":false,"excerpt":"These instructions show how to manually change a password to the word - \"secret\" Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen. Find and click on the table\u2026","rel":"","context":"In "Hosting Marketers News"","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":59,"url":"https:\/\/hosting-marketers.com\/news\/2008\/04\/07\/installing-phpmotion-v2-rc1\/","url_meta":{"origin":211,"position":2},"title":"Installing PHPmotion V3","author":"Admin","date":"April 7, 2008","format":false,"excerpt":"The following instructions only apply to Version 3 of PHPmotion. For V1 please refer to the instructions provided inside the downloaded zip file Download the the zipped file from PHPmotion, the version for PHP 5.x is the one which will work on our servers: http:\/\/downloads.phpmotion.com\/V3.5\/php5.2.x\/phpmotion.zip Before you begin Ensure that\u2026","rel":"","context":"In "Hosting Marketers News"","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":358,"url":"https:\/\/hosting-marketers.com\/news\/2012\/03\/30\/gyaro-video-chat\/","url_meta":{"origin":211,"position":3},"title":"Gyaro Video Chat","author":"Admin","date":"March 30, 2012","format":false,"excerpt":"Recently a new script for video chat come out, Gyaro, it looks a bit like Gchats, but the big advantage is that the red5 app doesn't connect to the script database, this renders it more stable. We tested also the new script Gyaro with wowza and it works great, this\u2026","rel":"","context":"In "Hosting Marketers News"","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":426,"url":"https:\/\/hosting-marketers.com\/news\/2013\/11\/15\/suphp-and-server-error\/","url_meta":{"origin":211,"position":4},"title":"suPHP and “Server Error”","author":"Admin","date":"November 15, 2013","format":false,"excerpt":"why you may get 500 Server Error on your site?","rel":"","context":"In "security"","block_context":{"text":"security","link":"https:\/\/hosting-marketers.com\/news\/category\/security\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6,"url":"https:\/\/hosting-marketers.com\/news\/2006\/09\/08\/what-is-the-difference-between-windows-and-unix-web-hosting\/","url_meta":{"origin":211,"position":5},"title":"What is the difference between Windows and UNIX web hosting?","author":"Admin","date":"September 8, 2006","format":false,"excerpt":"Windows and UNIX are in fact two different systems and of course we are referring to computer systems. A web host uses computers, (we shall refer to them as servers, just computers, but sometimes larger) to host websites, and all computers need a operating system, so Windows and UNIX are\u2026","rel":"","context":"In "Hosting Marketers News"","block_context":{"text":"Hosting Marketers News","link":"https:\/\/hosting-marketers.com\/news\/category\/hosting-marketers-news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":2,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":213,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/posts\/211\/revisions\/213"}],"wp:attachment":[{"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting-marketers.com\/news\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2. Select the database you wish to manage from the drop-down menu on the left<\/p>\n
\nPlease note that after your change the collation of a database only the new tables will be created with the new collation. All other tables remain with the collation, they were initially created.<\/p>\n","protected":false},"excerpt":{"rendered":"