Mysql system variables / character sets

software development
#1

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:

character_set_server
collation_server

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

Any help gratefully received,
CJ

#2

Never mind - found it.

From the mysql> prompt, enter:

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