How to check what your database encoding is set to

For a version 5 database, and if you use PHP MyAdmin, you can check what the database is set to by logging into PHP MyAdmin,

UTF-8 Database Setup

 

This screen shows a typical version 5 MySQL blank database setup settings. For example, my old version 4 database specified the following:

incorrect encoding of my old database

Where en-iso-8859-1 is equivalent to latin1.

 

However, you must also check what the individual tables are set to by clicking on one of the tables in the left frame:

database individual table encoding

 

And you can also check individual fields by clicking on Browse and / or Structure tabs on top:

database individual field encoding

 

In text-only mode for those with mobile devices, dialup, and images forcibly turned off: How to check the encoding of your database:

Open your database in PHP MyAdmin and click on the database name. Check your database collation type (note: this column will not be shown for MySQL version 4, since it defaulted to latin1).

With an incorrect import to MySQL version 5, collation will be listed as:

latin1_general_ci

or latin1_german_ci, or latin1_swedish_ci, or similar.

Your task is to have the collation set to:

utf8_general_ci

If you get it, utf8_unicode is a worse option according to my limited research (but I may be wrong on this one).



˅˅˅ Additional valuable information is available at one of the links below: ˅˅˅

 

Did you like the article? Let Google Search know by clicking this button: . Please link to content that you find useful on this website on your own website, forum or blog! You can also comment on this page below, or to ask a question or suggest a topic for me to research. There is a user-editable Wiki available on my website, as well as a Forum that you can contribute to. Site Map.

Page last modified 31-Dec-12 22:09:27 EST

Previous page: Preliminary Reading
Next page: What will not work

Comments on this page:


Add a comment to this page
Comment Title:
Your Name:
Your Email Address:
Notify me of new comments to this item:
Additional Comments:
This is a captcha-picture. It is used to prevent mass-access by robots. (see: www.captcha.net)