11

Is there a way in PHPMyAdmin to find out the charset of a table and/or a database?

The only thing that ist shown, is the collation. But as far as I understood, the collation only tells the database how to compare the data, and the charset tells the database how to store the data.

Improve this question

2 Answers 2

Reset to default
15

Try writing a SQL command:

SELECT * FROM information_schema.SCHEMATA S WHERE schema_name = "myDataBase";

You might want to check this answer and the comments on this ressoure;

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

Comments

2

Alternatively, you can also find it by just looking at the collation name itself in most of the cases. Say the collation name is "latin1_swedish_ci" then the character set for the database is "latin1".

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.