tags:

views:

316

answers:

3
+2  Q: 

mysql charset cli

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

+3  A: 
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).

Robert Gamble
A: 

Awesome! thanks!

ocergynohtna
+2  A: 

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;

sebthebert