Change default Charset

Question

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

I wonder why someone would want to do that ? UTF-8 can display characters of every language, 8859-1 can only display characters of western european languages (and not even a Euro sign). — DarkDust, Jan 23 '11 at 11:28

score 4 · Answer 1 · edited Feb 09 '16 at 21:06

4

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

edited Feb 09 '16 at 21:06

zheek

answered Jan 23 '11 at 11:26

Ismail

Hi. Not sure where to find that. – iMayne Jan 23 '11 at 11:35
1

Its on the left side frame you will find it on first bullet and reach to schemata – Ismail Jan 23 '11 at 12:15
That just for signle schema – Weijing Jay Lin Apr 29 '16 at 02:11
1

Tried this and got the following error: `Access denied for user root@localhost to database information_schema` – Timothé Malahieude Mar 01 '18 at 22:54

stivlo · Answer 2 · 2011-01-23T11:48:45.793

1

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

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

edited Jan 23 '11 at 11:48

answered Jan 23 '11 at 11:28

stivlo

score 0 · Answer 3 · edited Feb 09 '16 at 21:06

0

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

edited Feb 09 '16 at 21:06

zheek

answered Jan 23 '11 at 11:22

Stefan H Singer

Hey Stefan. Where do I find that config.php? Im using wordpress. – iMayne Jan 23 '11 at 11:24
1

Sorry! It's config.inc.php! It's got nothing to do with wordpress. You find it in your phpmyadmin directory. – Stefan H Singer Jan 23 '11 at 11:25
Ohhhhhh. Im not hosting my own server. Im with a company so I doubt I have access to that :( – iMayne Jan 23 '11 at 11:35
Well, you could probably upload your own phpmyadmin installation. But if you don't have access to their installation of phpmyadmin on disk, you can't change its config either. – Stefan H Singer Jan 23 '11 at 12:24

3 Answers3