m |
m |
||
| Line 1: | Line 1: | ||
| − | <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. | + | <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 (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; | ||
.jpg)
