Change default Charset

Question

How do I change the default charset from UTF-8 to ISO-8859-1 in phpMyAdmin?

Answer 1

You need to go to phpmyadmin > information_schema > schemata > change your DEFAULT_CHARACTER_SET_NAME with query

Answer 2

Find your config.inc.php and add or edit the line

$cfg['DefaultCharset'] = 'iso-8859-1';

Answer 3

You can change the default charset in your config.php $cfg['DefaultLang'] = 'ISO-8859-1';