Character set issues affect not only data storage, but also communication between client programs and the MySQL server.
If you want the client program to communicate with the server using a character set different from the default, you'll need to indicate which one.
For example, to use the utf8 Unicode character set, issue this statement after connecting to the server:
SET NAMES 'utf8';