Hi,
SQLyog as defualt uses utf8 internally (refer FAQ http://faq.webyog.com/content/8/148/en/do-i-need-to-set-names-to-display-characters-of-my-language.html – when it says “Actually you SHOULD NEVER issue any SET NAMES statement from the SQLyog GUI yourself” it does not apply to utf8_mb4) and refer documentation on INIT_COMMANDS in SQLyog at http://sqlyogkb.webyog.com/article/158-advanced-connection-settings.
You can enter “SET NAMES utf8mb4” in the ‘Init Command(s)’ field under the ‘Advanced’ tab of the Connection window.
Once the connection is established, you may execute “SHOW VARIABLES LIKE ‘char%’;” to verify the change.
Regards,
Sibin