CODEWITHSUNDEEP
mysqlcharacter-encodingcommand-line-interface
ocergynohtna
ocergynohtna

Reputation: 1702

mysql charset cli

how do i determine what a mysql db's charset is set to? in the cli?

Upvotes: 3

Views: 933

Answers (2)

sebthebert
sebthebert

Reputation: 12507

You can use the command "show table status",

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

mysql> show table status;

Upvotes: 1

Robert Gamble
Robert Gamble

Reputation: 109182

SHOW CREATE DATABASE db-name

Will show you the default character set for the database,

SHOW CREATE TABLE db-name.table-name

Will show you the character set for a specific table (along with a lot of other information).

Upvotes: 8

Related Questions