Bug 796209

Summary:	dev-db/mysql mysql client reject non-ascii characters
Product:	Gentoo Linux	Reporter:	Pavel Riha <pavel.riha>
Component:	Current packages	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	UNCONFIRMED ---
Severity:	normal	CC:	mscardovi
Priority:	Normal
Version:	unspecified
Hardware:	AMD64
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	emerge --info

Description Pavel Riha 2021-06-15 10:52:27 UTC

tested on 
mysql  Ver 8.0.23 for Linux on x86_64 (Gentoo Linux mysql-8.0.23)

it's not possible to type or paste non-ascii characters (ex. czech ščřž or chinese SELECT 'Chinese characters <汉字> are stripped';)

look's exactly like theese old bug reports 
https://bugzilla.redhat.com/show_bug.cgi?id=1187469
https://bugs.mysql.com/bug.php?id=76324
but this should be after 6 years fixed in 8.0.20, but I have 8.0.23 and it's not working

the problem is in mysql client console, not the database itself (phpmyadmin can store the characters)




Reproducible: Always

Comment 1 Pavel Riha 2021-06-15 10:53:06 UTC

Created attachment 716280 [details]
emerge --info

Comment 2 Pavel Riha 2021-06-15 10:55:12 UTC

tested on some my old servers with mysql 5.6 and 5.7 and there it is working
on two different instalation with 8.0.23 is not working