How to change database collation

m (Created page with "<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 wi...")
 
m
Line 2: Line 2:
 
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 'Databases';
+
'''1'''. Log into your '''cPanel => phpMyAdmin''' located under ['''Databases'''];
  
 
'''2'''. Select the needed DB from left-side list;
 
'''2'''. Select the needed DB from left-side list;
  
'''3'''. Click on 'Operations' in the top menu;
+
'''3'''. Click on '''Operations''' in the top menu;
  
 
  {{#icon: DB collation.png|change DB collation}}
 
  {{#icon: DB collation.png|change DB collation}}
  
'''4'''. Select the database collation needed from the drop-down menu and click 'Go'.
+
'''4'''. Select the database collation needed from the drop-down menu and click '''Go'''.
  
 
  {{#icon: change DB collation.png|change DB collation}}
 
  {{#icon: change DB collation.png|change DB collation}}

Revision as of 12:16, 14 November 2011

rss feed for my website