Replace Latin Swedish with Unicode in PhpMyAdmin
Submitted by lev_lafayette on Sun, 12/09/2012 - 02:36When establishing a website database (e.g., Drupal, Wordpress etc) with PhpMyAdmin (e.g., through CPanel) one may be surprised to discover that the default character collation order is in latin1_swedish_ci
. For most "plain text" ASCII-style posts this isn't a problem. It becomes a problem however when an article is supposed to display characters which require a different character set. A personal discovery of this nature was with Esperanto diacritical characters. Characters which latin1_swedish_ci
cannot display will be replaced with "?", one per character.