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: | |
Category: | MySQL Server: Options | Severity: | S3 (Non-critical) |
Version: | 5.5.11 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[19 May 2011 22:14]
- -
[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.