m |
m |
||
Line 1: | Line 1: | ||
<seo title="How to change database collation" metakeywords="database collation,change database collation,sql collation" metadescription="How to change database collation" /> | <seo title="How to change database collation" metakeywords="database collation,change database collation,sql collation" metadescription="How to change database collation" /> | ||
− | <div align=justify>In case you are having problems with foreign character encodings, you can try to resolve them by changing the DB collation from latin1 to utf8. | + | <div align=justify>In case you are having problems with foreign character encodings, you can try to resolve them by changing the DB collation (sql collation) from latin1 to utf8. |
This article will provide you with the steps needed to change the database collation. | This article will provide you with the steps needed to change the database collation. | ||
− | '''1'''. Log into your '''cPanel => phpMyAdmin''' located under | + | '''1'''. Log into your '''cPanel => phpMyAdmin''' located under '''[[Databases]]'''; |
− | '''2'''. Select the needed DB from left-side list; | + | '''2'''. Select the needed DB from the left-side list; |
'''3'''. Click on '''Operations''' in the top menu; | '''3'''. Click on '''Operations''' in the top menu; |