utf8 non ascii characters are not accepted in the mysql cli when launched with --default-character-set=utf8
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned | ||
Bionic |
Fix Released
|
Undecided
|
Unassigned | ||
mysql-8.0 (Ubuntu) |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
When you type
SELECT "é" AS letter;
at the prompt of the command line interface of the mysql client, the letter with an accent will not be echoed at the command line and the result of the command will be an empty field instead of a field containing the letter "é", as if the next command was issued:
SELECT "" AS letter;
As a workaround, you send letters with accents through a pipeline to the mysql client, typing at the shell prompt:
echo 'SELECT "é" AS letter;' | mysql
This version of the mysql client is configured to use the EditLine wrapper, which seems to be guilty of this behaviour.
ProblemType: Bug
DistroRelease: Ubuntu 18.04
Package: mysql-client-
ProcVersionSign
Uname: Linux 4.15.0-70-generic x86_64
ApportVersion: 2.20.9-0ubuntu7.9
Architecture: amd64
CurrentDesktop: ubuntu:GNOME
Date: Mon Nov 25 10:47:10 2019
InstallationDate: Installed on 2018-02-26 (636 days ago)
InstallationMedia: Ubuntu 17.10 "Artful Aardvark" - Release amd64 (20180105.1)
KernLog:
Logs.var.
Logs.var.
MySQLConf.
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
SourcePackage: mysql-5.7
UpgradeStatus: Upgraded to bionic on 2018-05-08 (565 days ago)
summary: |
- utf8 non ascii characters are not accepted as input of the mysql command - line + utf8 non ascii characters are not accepted in the mysql cli when + launched with --default-character-set=utf8 |
Output of `mysql --version` is:
mysql Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using EditLine wrapper