Mysql charset cli

Question

how to determine what mysql db character set is configured for? in cli?

Answer 1

SHOW CREATE DATABASE db-name

Show you the default character set for the database,

SHOW CREATE TABLE db-name.table-name

Show you the character set for a particular table (along with a lot of other information).

Answer 2

You can use the "show table status" command,

it will show you a lot of information (including a character set) about your tables

mysql> show table status;