[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: |
|
| Description |
|
[root@qiao /]# mysql 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
from console. | ||
| 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/ |