Bug #422 4.1 libedit strange behaviour with åäö
Submitted: 13 May 2003 4:47 Modified: 1 Jul 2003 2:46
Reporter: Jeremy Cole (Basic Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:4.1.x OS:Any (All)
Assigned to: Bugs System CPU Architecture:Any

[13 May 2003 4:47] Jeremy Cole
Description:
When trying to edit a string containing any special characters, the clinet "bugs out" :)

How to repeat:

mysql> select "Mårten";

Now go try to use the up, left, right arrow keys to edit that line.
[20 Jun 2003 8:43] Lenz Grimmer
This is actually a libedit problem. Compiling the client with the readline
library should fix this problem. Victor, can you please investigate this?
[1 Jul 2003 2:46] Victor Vagin
I'm sorry, I thought it was common localization-bug..
I already fixed all localization problems in April.. and I think
problem is in pulling of new version.. At least, mysql works quite
well with Russian symbols

I tuned my console for Swedish,
and :

-------------------------
Version: '4.1.1-alpha-debug'  socket: '/tmp/mysql-vva.sock'  port: 3306
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.1-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> create table a(b varchar(200));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a(b)values("Mårten");
Query OK, 1 row affected (0.00 sec)

mysql> insert into a(b)values("åäö");
Query OK, 1 row affected (0.00 sec)

mysql> select * from a;
+--------+
| b      |
+--------+
| Mårten |
| åäö    |
+--------+
2 rows in set (0.00 sec)

mysql> select "Mårten";
+--------+
| Mårten |
+--------+
| Mårten |
+--------+
1 row in set (0.00 sec)
----------------------------

I used left, right, top and bottom arrows at lines with 'åäö' without
any problems..
So, I think problem's locale settings..

If this bug's still actual, please, send me result of
locale command. For example:
--------------------
vva@eagle:~/work/mysql.orig/clear/mysql-4.1 > locale
LANG=en_US
LC_CTYPE="en_US"
LC_NUMERIC="en_US"
LC_TIME="en_US"
LC_COLLATE=POSIX
LC_MONETARY="en_US"
LC_MESSAGES="en_US"
LC_PAPER="en_US"
LC_NAME="en_US"
LC_ADDRESS="en_US"
LC_TELEPHONE="en_US"
LC_MEASUREMENT="en_US"
LC_IDENTIFICATION="en_US"
LC_ALL=
--------------------

And, check settings of your terminal-client 
(I used PuTTY release 0.52 for Windows, and set 
option Window/Translation to "ISO-8859-1:1998 (Latin-1, West Europe)")