Bug #93136 client character set is still utf8 on workbench 8.0.13

• Submitted: 9 Nov 2018 4:50
• Modified: 3 Sep 2019 15:54
• Reporter: Shinya Sugiyama
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.13, 8.0.15
• OS: Windows
• CPU Architecture: Any

[9 Nov 2018 4:50] Shinya Sugiyama

Description:
When we connect to MySQL Instances with Workbench 8.0.13, it seems still connecting with utf8.

https://dev.mysql.com/doc/relnotes/workbench/en/wb-news-8-0-12.html

MySQL Workbench now uses utf8mb4 as the connection and client character set, replacing utf8mb3.

How to repeat:
■ session variable
 show variables like '%char%';

'character_set_client', 'utf8'

■ global variable
show global variables like 'character_set_client';

'character_set_client', 'utf8mb4'

Suggested fix:
"show variables like '%char%'" should be utf8mb4,

[9 Nov 2018 4:51] Shinya Sugiyama

Add version

[9 Nov 2018 7:42] Shinya Sugiyama

session variable

Attachment: session_variable.PNG (image/png, text), 24.67 KiB.

[9 Nov 2018 7:43] Shinya Sugiyama

Global Variables

Attachment: global_variable.PNG (image/png, text), 24.81 KiB.

[12 Nov 2018 12:51] MySQL Verification Team

Hello Shinya Sugiyama,

Thank you for the report.
Issue is seen while connecting 5.7.24 instance.

##
## MySQL Server 8.0.13 + WB 8.0.13 on Win7
## CLI
mysql> \s
--------------
bin/mysql  Ver 8.0.13 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

Connection id:          7
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          more
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.13 MySQL Community Server - GPL
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4

## WB
show global variables like 'character_set_c%';
# Variable_name, Value
'character_set_client', 'utf8mb4'
'character_set_connection', 'utf8mb4'

show variables like 'character_set_c%';
# Variable_name, Value
'character_set_client', 'utf8mb4'
'character_set_connection', 'utf8mb4'

## MySQL Server 5.7.24 + WB 8.0.13 on Win7

mysql> \s
--------------
## CLI

mysql> \s
--------------
bin/mysql  Ver 14.14 Distrib 5.7.24, for linux-glibc2.12 (x86_64) using  EditLine wrapper

Connection id:          2
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          more
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.24 MySQL Community Server (GPL)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8
Conn.  characterset:    utf8

## WB
show variables like 'character_set_c%';
# Variable_name, Value
'character_set_client', 'utf8'
'character_set_connection', 'utf8'

show global variables like 'character_set_c%';
# Variable_name, Value
'character_set_client', 'utf8mb4'
'character_set_connection', 'utf8mb4'

Thanks,
Umesh

[13 Nov 2018 0:55] Shinya Sugiyama

Hi Umesh,

Thank you for your quick confirmation as always.
I thought it is workbench side configuration though...

Best Regards
Shinya

[15 Apr 2019 5:45] MySQL Verification Team

Bug #95014 marked as duplicate of this one

[3 Sep 2019 15:54] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.18 release, and here's the changelog entry:

Connections made to 5.6 and 5.7 server instances defaulted to the utf8
character set, instead of utf8mb4.

Thank you for the bug report.