Database charset

How to specify a charset for a MySql connection?