CODEWITHSUNDEEP
mysql
Ben
Ben

Reputation: 62374

Checking MySQL character set

I've modified my my.cnf file but I'm unsure how I can check to see if my character set is now set to UTF-8? Is there a simple command or something I can run to check?

Upvotes: 0

Views: 177

Answers (1)

Dan Grossman
Dan Grossman

Reputation: 52372

Yes, there is:

SHOW VARIABLES;

Note that you also have a connection character set, table character set and column character set. SHOW CREATE TABLE [identifier] will be useful if you're unsure what these are set to.

Upvotes: 2

Related Questions