Mysql system variables / character sets

Hi there,

Anyone know how I can check my MySQL system variables? I have shell access (SSH) and want to determine what the MySQL server’s current character set and collation are.

Apparently these are stored in the following system variables:


so is there some way I can display these from the command line?

Any help gratefully received,

Never mind - found it.

From the mysql> prompt, enter:

show variables;and this lists all the variables, including character_set_server and friends.