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 contact me 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)