Bug #61234 SET NAMES 'utf8mb4' does not work
Submitted: 19 May 2011 22:14 Modified: 20 May 2011 6:55
Reporter: - - Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.5.11 OS:Linux
Assigned to: CPU Architecture:Any

[19 May 2011 22:14] - -
Description:
SET NAMES 'utf8mb4' does not work (sets character_set_client and character_set_results to utf8mb4 and gives error "Character set 'utf8mb4' is not supported") while SET CHARACTER SET utf8mb4, CHARACTER_SET_CONNECTION = utf8mb4; does. 

How to repeat:
SET NAMES 'utf8mb4';
SET CHARACTER SET utf8mb4, CHARACTER_SET_CONNECTION = utf8mb4;
[19 May 2011 23:01] MySQL Verification Team
Thank you for the bug report. Which binaries are you using our package our self-compiled?

C:\DBS>c:\dbs\5.5\bin\mysql -uroot --port=3540 --prompt="mysql 5.5 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.13-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.5 >SET NAMES 'utf8mb4';
Query OK, 0 rows affected (0.00 sec)

mysql 5.5 >SET CHARACTER SET utf8mb4, CHARACTER_SET_CONNECTION = utf8mb4;
Query OK, 0 rows affected (0.00 sec)

mysql 5.5 >show variables like "%charac%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | c:\dbs\5.5\share\charsets\ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql 5.5 >
[20 May 2011 6:55] - -
Sorry for the wrong bug report, it seems that the problem is not in mysql, but in a tool for it. Via mysql.exe everything is OK for me too.