How do I change the charset in phpmyadmin?

To do this, you would edit
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.default.php
and change the following lines:



$cfg[‘DefaultCharset’] = ‘iso-8859-1’;

$cfg[‘DefaultLang’] = ‘en-iso-8859-1’;



If you wish to find a list of available charsets, you can run the following command:



grep -A 35 AvailableCharsets /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/config.default.php



And to find the list of available languages, the following command will provide that information:



grep -A 120 ‘available_languages = array(‘
 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/select_lang.lib.php

Your rating: None Average: 1 (1 vote)