Unsupported Screen Size: The viewport size is too small for the theme to render properly.

utf8mb4 support

forums forums SQLyog Using SQLyog utf8mb4 support

Tagged: ,

Viewing 1 reply thread
  • Author
    • #35973
      Julian Vidal


      I’m having trouble seeing the correct characters in my tables that are set to utf8yes..mb4. When I query the DB with a test PHP script and render that on an HTML page, I can see emoticons just fine but in SQLyog, these emoticons appear as small squares.

      Also when I issue the following query:

      SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

      I always get:

      Variable_name             Value               
      ------------------------  --------------------
      character_set_client      utf8                
      character_set_connection  utf8      

      so I think SQLyog is refusing to connect using utf8mb4. Where can I set that option? Can’t find it anywhere.

      PS: I’m currently using SQLyog Ultimate 12.4.1 (64 bit)

    • #35975
      Sibin A S


      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.


Viewing 1 reply thread
  • You must be logged in to reply to this topic.