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
– DarkDust, Commented Jan 23, 2011 at 11:28

zheek · Accepted Answer · 2016-02-09 21:06:39Z

5

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

edited Feb 9, 2016 at 21:06

zheek

7521 gold badge11 silver badges22 bronze badges

answered Jan 23, 2011 at 11:26

Ismail

6441 gold badge6 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

iMayne Over a year ago

Hi. Not sure where to find that.

Ismail Over a year ago

Its on the left side frame you will find it on first bullet and reach to schemata

Weijing Jay Lin Over a year ago

That just for signle schema

Timothé Malahieude Over a year ago

Tried this and got the following error: Access denied for user root@localhost to database information_schema

stivlo · Accepted Answer · 2011-01-23 11:48:45Z

1

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

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

edited Jan 23, 2011 at 11:48

answered Jan 23, 2011 at 11:28

stivlo

85.9k35 gold badges148 silver badges200 bronze badges

Comments

zheek · Accepted Answer · 2016-02-09 21:06:28Z

0

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

edited Feb 9, 2016 at 21:06

zheek

7521 gold badge11 silver badges22 bronze badges

answered Jan 23, 2011 at 11:22

Stefan H Singer

5,4942 gold badges27 silver badges26 bronze badges

4 Comments

iMayne Over a year ago

Hey Stefan. Where do I find that config.php? Im using wordpress.

Stefan H Singer Over a year ago

Sorry! It's config.inc.php! It's got nothing to do with wordpress. You find it in your phpmyadmin directory.

iMayne Over a year ago

Ohhhhhh. Im not hosting my own server. Im with a company so I doubt I have access to that :(

Stefan H Singer Over a year ago

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.

Collectives™ on Stack Overflow

Change default Charset

3 Answers 3

4 Comments

Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

4 Comments

Linked

Related