The MySQL client must be recompiled with the given character set to solve the problem. To recompile you must run the configure command.
>./configure --with-extra-charsets = (CharacterSetName)
(CharacterSetName) in here is the variable which is not supported by your MySQL client.