utf8mb4 support

[Julian Vidal]

Hi,

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)

[Sibin A S]

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

[Author]

Posts