[MDEV-13543] MariaDB command client don't support non ACSII character Created: 2017-08-16  Updated: 2017-08-21  Resolved: 2017-08-21

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Scripts & Clients
Affects Version/s: 10.2.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Joe Guo Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7 x86_64


Attachments: PNG File create none ascii name database.png     PNG File mysql-client-input-chinese.png     PNG File non-ascii support.png    

 Description   

[root@qiao /]# mysql
MariaDB [(none)]> create database 测试;

If I want to run above sql, the mariadb command client will delete non ASCII character.



 Comments   
Comment by Alice Sherepa [ 2017-08-16 ]

please provide output (and the screenshot) of

mysql -e "create database 测试" 
locale

from console.
Is it possible to use this symbols without mysql?

Comment by Joe Guo [ 2017-08-16 ]

Comment by Joe Guo [ 2017-08-16 ]

I use Chinese character as database name, table name, and column name in MariaDB for a long time, it work fine for me, and just not usable in command line client.

Comment by Elena Stepanova [ 2017-08-17 ]

qiao,

Where do MariaDB packages that you use come from?

Your screenshot says that the client uses EditLine . To the best of our knowledge, the only packages that we provide with EditLine are Fedora 24, but you have CentOS7, so there is no reason why you would install Fedora's packages, right? (And you probably wouldn't be able to, anyway)

The other possibility is that you're building from source, is it the case? If so, could you maybe try to install readline and build with it instead? I'm not sure if it solves the problem, as I don't have environment to reproduce it so far, but it might.

Comment by Joe Guo [ 2017-08-17 ]

I build the binary rpm use Fedora 27 source rpm on CentOS 7, default it depend on libedit-devel, will cause the non ascii input problem, now I change depend to readline-devel, the problem resolved, thanks for your reply.

Comment by Elena Stepanova [ 2017-08-17 ]

qiao, thanks for confirming.

greenman, I think it might be worth mentioning in documentation, that we normally build with readline and recommend it to those who build from sources, especially if users experience problems with non-ascii symbols.

Our only known exception is Fedora 24, but it's EOL-ed, so it is probably the last release when we provide it anyway.

Comment by Ian Gilfillan [ 2017-08-21 ]

I have added a specific mention of readline to https://mariadb.com/kb/en/mariadb/generic-build-instructions/

Generated at Thu Feb 08 08:06:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.