How to change database collation

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 ['''Databases'''];
+
'''1'''. Log into your '''cPanel => phpMyAdmin''' located under '''[[Databases]]''';
  
 
'''2'''. Select the needed DB from the left-side list;
 
'''2'''. Select the needed DB from the left-side list;

Latest revision as of 06:24, 21 November 2011

rss feed for my website