Public bug reported:
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-core-5.7 5.7.28-0ubuntu0.18.04.4
ProcVersionSignature: Ubuntu 4.15.0-70.79-generic 4.15.18
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.log.daemon.log:
Logs.var.log.mysql.error.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: False
SourcePackage: mysql-5.7
UpgradeStatus: Upgraded to bionic on 2018-05-08 (565 days ago)
** Affects: mysql-5.7 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug bionic
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1853818
Title:
utf8 non ascii characters are not accepted as input of the mysql
command line
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1853818/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
