View source

<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.
This article will provide you with the steps needed to change the database collation.

'''1'''. Log into your '''cPanel => phpMyAdmin''' located under ['''Databases'''];

'''2'''. Select the needed DB from the left-side list;

'''3'''. Click on '''Operations''' in the top menu;

 {{#icon: DB collation.png|change DB collation}}

'''4'''. Select the database collation needed from the drop-down menu and click '''Go'''.

 {{#icon: change DB collation.png|change DB collation}}

In case there are still any issues, you can try to change the database collation to a different one.


'''Note:''' after you change the database collation only the new tables will be created with the new collation. All other tables will remain with the original collation.</div>

Return to How to change database collation.

Retrieved from "http://myidealhost.com/tutorials/How_to_change_database_collation"

Navigation

Search